DBA Data[Home] [Help]

APPS.GMF_API_WRP dependencies on GMF_BURDENDETAILS_PUB

Line 4340: l_header_rec GMF_BurdenDetails_PUB.Burden_Header_Rec_Type;

4336: l_record_count NUMBER(10) :=0;
4337: l_loop_cnt NUMBER(10) :=0;
4338: l_dummy_cnt NUMBER(10) :=0;
4339: l_data VARCHAR2(1000);
4340: l_header_rec GMF_BurdenDetails_PUB.Burden_Header_Rec_Type;
4341: l_dtl_tbl GMF_BurdenDetails_PUB.Burden_Dtl_Tbl_Type;
4342: l_burdenline_ids GMF_BurdenDetails_PUB.Burdenline_Ids_Tbl_Type;
4343: l_p_dir VARCHAR2(150);
4344: l_output_file VARCHAR2(120);

Line 4341: l_dtl_tbl GMF_BurdenDetails_PUB.Burden_Dtl_Tbl_Type;

4337: l_loop_cnt NUMBER(10) :=0;
4338: l_dummy_cnt NUMBER(10) :=0;
4339: l_data VARCHAR2(1000);
4340: l_header_rec GMF_BurdenDetails_PUB.Burden_Header_Rec_Type;
4341: l_dtl_tbl GMF_BurdenDetails_PUB.Burden_Dtl_Tbl_Type;
4342: l_burdenline_ids GMF_BurdenDetails_PUB.Burdenline_Ids_Tbl_Type;
4343: l_p_dir VARCHAR2(150);
4344: l_output_file VARCHAR2(120);
4345: l_outfile_handle UTL_FILE.FILE_TYPE;

Line 4342: l_burdenline_ids GMF_BurdenDetails_PUB.Burdenline_Ids_Tbl_Type;

4338: l_dummy_cnt NUMBER(10) :=0;
4339: l_data VARCHAR2(1000);
4340: l_header_rec GMF_BurdenDetails_PUB.Burden_Header_Rec_Type;
4341: l_dtl_tbl GMF_BurdenDetails_PUB.Burden_Dtl_Tbl_Type;
4342: l_burdenline_ids GMF_BurdenDetails_PUB.Burdenline_Ids_Tbl_Type;
4343: l_p_dir VARCHAR2(150);
4344: l_output_file VARCHAR2(120);
4345: l_outfile_handle UTL_FILE.FILE_TYPE;
4346: l_input_file VARCHAR2(120);

Line 4773: l_header_rec GMF_BurdenDetails_PUB.Burden_Header_Rec_Type;

4769: l_record_count NUMBER(10) :=0;
4770: l_loop_cnt NUMBER(10) :=0;
4771: l_dummy_cnt NUMBER(10) :=0;
4772: l_data VARCHAR2(1000);
4773: l_header_rec GMF_BurdenDetails_PUB.Burden_Header_Rec_Type;
4774: l_dtl_tbl GMF_BurdenDetails_PUB.Burden_Dtl_Tbl_Type;
4775: l_p_dir VARCHAR2(150);
4776: l_output_file VARCHAR2(120);
4777: l_outfile_handle UTL_FILE.FILE_TYPE;

Line 4774: l_dtl_tbl GMF_BurdenDetails_PUB.Burden_Dtl_Tbl_Type;

4770: l_loop_cnt NUMBER(10) :=0;
4771: l_dummy_cnt NUMBER(10) :=0;
4772: l_data VARCHAR2(1000);
4773: l_header_rec GMF_BurdenDetails_PUB.Burden_Header_Rec_Type;
4774: l_dtl_tbl GMF_BurdenDetails_PUB.Burden_Dtl_Tbl_Type;
4775: l_p_dir VARCHAR2(150);
4776: l_output_file VARCHAR2(120);
4777: l_outfile_handle UTL_FILE.FILE_TYPE;
4778: l_input_file VARCHAR2(120);

Line 4876: GMF_BurdenDetails_PUB.Get_Burden_Details

4872: UTL_FILE.PUT_LINE(l_log_handle, 'cost_mthd_code = ' || l_header_rec.cost_mthd_code) ;
4873: UTL_FILE.PUT_LINE(l_log_handle, 'user_name = ' || l_header_rec.user_name) ;
4874:
4875: -- Invoke public get burden details
4876: GMF_BurdenDetails_PUB.Get_Burden_Details
4877: (
4878: p_api_version => 2.0
4879: , p_init_msg_list => FND_API.G_TRUE
4880:

Line 5047: p_burden_header IN GMF_BurdenDetails_PUB.Burden_Header_Rec_Type

5043: +==========================================================================+
5044: */
5045: PROCEDURE Call_Burden_API
5046: (
5047: p_burden_header IN GMF_BurdenDetails_PUB.Burden_Header_Rec_Type
5048: , p_burden_detail IN GMF_BurdenDetails_PUB.Burden_Dtl_Tbl_Type
5049: , p_operation IN VARCHAR2
5050: , x_burdenline_ids OUT NOCOPY GMF_BurdenDetails_PUB.Burdenline_Ids_Tbl_Type
5051: , x_status OUT NOCOPY VARCHAR2

Line 5048: , p_burden_detail IN GMF_BurdenDetails_PUB.Burden_Dtl_Tbl_Type

5044: */
5045: PROCEDURE Call_Burden_API
5046: (
5047: p_burden_header IN GMF_BurdenDetails_PUB.Burden_Header_Rec_Type
5048: , p_burden_detail IN GMF_BurdenDetails_PUB.Burden_Dtl_Tbl_Type
5049: , p_operation IN VARCHAR2
5050: , x_burdenline_ids OUT NOCOPY GMF_BurdenDetails_PUB.Burdenline_Ids_Tbl_Type
5051: , x_status OUT NOCOPY VARCHAR2
5052: , x_count OUT NOCOPY NUMBER

Line 5050: , x_burdenline_ids OUT NOCOPY GMF_BurdenDetails_PUB.Burdenline_Ids_Tbl_Type

5046: (
5047: p_burden_header IN GMF_BurdenDetails_PUB.Burden_Header_Rec_Type
5048: , p_burden_detail IN GMF_BurdenDetails_PUB.Burden_Dtl_Tbl_Type
5049: , p_operation IN VARCHAR2
5050: , x_burdenline_ids OUT NOCOPY GMF_BurdenDetails_PUB.Burdenline_Ids_Tbl_Type
5051: , x_status OUT NOCOPY VARCHAR2
5052: , x_count OUT NOCOPY NUMBER
5053: , x_data OUT NOCOPY VARCHAR2
5054: )

Line 5060: GMF_BurdenDetails_PUB.Create_Burden_Details

5056:
5057: BEGIN
5058:
5059: IF p_operation = 'INSERT' THEN
5060: GMF_BurdenDetails_PUB.Create_Burden_Details
5061: (
5062: p_api_version => 2.0
5063: , p_init_msg_list => FND_API.G_TRUE
5064: , p_commit => FND_API.G_TRUE

Line 5076: GMF_BurdenDetails_PUB.Update_Burden_Details

5072:
5073: , x_burdenline_ids => x_burdenline_ids
5074: );
5075: ELSIF p_operation = 'UPDATE' THEN
5076: GMF_BurdenDetails_PUB.Update_Burden_Details
5077: (
5078: p_api_version => 2.0
5079: , p_init_msg_list => FND_API.G_TRUE
5080: , p_commit => FND_API.G_TRUE

Line 5090: GMF_BurdenDetails_PUB.Delete_Burden_Details

5086: , p_header_rec => p_burden_header
5087: , p_dtl_tbl => p_burden_detail
5088: );
5089: ELSIF p_operation = 'DELETE' THEN
5090: GMF_BurdenDetails_PUB.Delete_Burden_Details
5091: (
5092: p_api_version => 2.0
5093: , p_init_msg_list => FND_API.G_TRUE
5094: , p_commit => FND_API.G_TRUE