DBA Data[Home] [Help]

APPS.GMF_API_WRP dependencies on GMF_RESOURCECOST_PUB

Line 5218: rsrc_rec GMF_ResourceCost_PUB.Resource_Cost_Rec_Type;

5214: l_record_count NUMBER(10) :=0;
5215: l_loop_cnt NUMBER(10) :=0;
5216: l_dummy_cnt NUMBER(10) :=0;
5217: l_data VARCHAR2(1000);
5218: rsrc_rec GMF_ResourceCost_PUB.Resource_Cost_Rec_Type;
5219: l_p_dir VARCHAR2(150);
5220: l_output_file VARCHAR2(120);
5221: l_outfile_handle UTL_FILE.FILE_TYPE;
5222: l_input_file VARCHAR2(120);

Line 5318: GMF_ResourceCost_PUB.Create_Resource_Cost

5314: UTL_FILE.PUT_LINE(l_log_handle, 'nominal_cost = ' || rsrc_rec.nominal_cost);
5315: UTL_FILE.PUT_LINE(l_log_handle, 'delete_mark = ' || rsrc_rec.delete_mark);
5316: UTL_FILE.PUT_LINE(l_log_handle, 'user_name = ' || rsrc_rec.user_name);
5317:
5318: GMF_ResourceCost_PUB.Create_Resource_Cost
5319: ( p_api_version => 2.0
5320: , p_init_msg_list => FND_API.G_TRUE
5321: , p_commit => FND_API.G_TRUE
5322:

Line 5555: rsrc_rec GMF_ResourceCost_PUB.Resource_Cost_Rec_Type;

5551: l_record_count NUMBER(10) :=0;
5552: l_loop_cnt NUMBER(10) :=0;
5553: l_dummy_cnt NUMBER(10) :=0;
5554: l_data VARCHAR2(2000);
5555: rsrc_rec GMF_ResourceCost_PUB.Resource_Cost_Rec_Type;
5556: l_p_dir VARCHAR2(150);
5557: l_output_file VARCHAR2(120);
5558: l_outfile_handle UTL_FILE.FILE_TYPE;
5559: l_input_file VARCHAR2(120);

Line 5660: GMF_ResourceCost_PUB.Update_Resource_Cost

5656: UTL_FILE.PUT_LINE(l_log_handle, 'delete_mark = ' || rsrc_rec.delete_mark);
5657: UTL_FILE.PUT_LINE(l_log_handle, 'user_name = ' || rsrc_rec.user_name);
5658:
5659: -- DBMS_OUTPUT.PUT_LINE('before calling Update API...');
5660: GMF_ResourceCost_PUB.Update_Resource_Cost
5661: ( p_api_version => 2.0
5662: , p_init_msg_list => FND_API.G_TRUE
5663: , p_commit => FND_API.G_TRUE
5664:

Line 5898: rsrc_rec GMF_ResourceCost_PUB.Resource_Cost_Rec_Type;

5894: l_record_count NUMBER(10) :=0;
5895: l_loop_cnt NUMBER(10) :=0;
5896: l_dummy_cnt NUMBER(10) :=0;
5897: l_data VARCHAR2(2000);
5898: rsrc_rec GMF_ResourceCost_PUB.Resource_Cost_Rec_Type;
5899: l_p_dir VARCHAR2(150);
5900: l_output_file VARCHAR2(120);
5901: l_outfile_handle UTL_FILE.FILE_TYPE;
5902: l_input_file VARCHAR2(120);

Line 6004: GMF_ResourceCost_PUB.Delete_Resource_Cost

6000: UTL_FILE.PUT_LINE(l_log_handle, 'delete_mark = ' || rsrc_rec.delete_mark);
6001: UTL_FILE.PUT_LINE(l_log_handle, 'user_name = ' || rsrc_rec.user_name);
6002:
6003: -- DBMS_OUTPUT.PUT_LINE('before calling Delete API...');
6004: GMF_ResourceCost_PUB.Delete_Resource_Cost
6005: ( p_api_version => 2.0
6006: , p_init_msg_list => FND_API.G_TRUE
6007: , p_commit => FND_API.G_TRUE
6008:

Line 6231: rsrc_rec GMF_ResourceCost_PUB.Resource_Cost_Rec_Type;

6227: l_record_count NUMBER(10) :=0;
6228: l_loop_cnt NUMBER(10) :=0;
6229: l_dummy_cnt NUMBER(10) :=0;
6230: l_data VARCHAR2(2000);
6231: rsrc_rec GMF_ResourceCost_PUB.Resource_Cost_Rec_Type;
6232: x_rsrc_rec GMF_ResourceCost_PUB.Resource_Cost_Rec_Type;
6233: l_p_dir VARCHAR2(150);
6234: l_output_file VARCHAR2(120);
6235: l_outfile_handle UTL_FILE.FILE_TYPE;

Line 6232: x_rsrc_rec GMF_ResourceCost_PUB.Resource_Cost_Rec_Type;

6228: l_loop_cnt NUMBER(10) :=0;
6229: l_dummy_cnt NUMBER(10) :=0;
6230: l_data VARCHAR2(2000);
6231: rsrc_rec GMF_ResourceCost_PUB.Resource_Cost_Rec_Type;
6232: x_rsrc_rec GMF_ResourceCost_PUB.Resource_Cost_Rec_Type;
6233: l_p_dir VARCHAR2(150);
6234: l_output_file VARCHAR2(120);
6235: l_outfile_handle UTL_FILE.FILE_TYPE;
6236: l_input_file VARCHAR2(120);

Line 6338: GMF_ResourceCost_PUB.Get_Resource_Cost

6334: UTL_FILE.PUT_LINE(l_log_handle, 'delete_mark = ' || rsrc_rec.delete_mark);
6335: UTL_FILE.PUT_LINE(l_log_handle, 'user_name = ' || rsrc_rec.user_name);
6336:
6337: -- DBMS_OUTPUT.PUT_LINE('before calling Get Resource Cost Public API...');
6338: GMF_ResourceCost_PUB.Get_Resource_Cost
6339: ( p_api_version => 2.0
6340: , p_init_msg_list => FND_API.G_TRUE
6341:
6342: , x_return_status =>l_status