eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_API_WRP dependencies on GMF_ITEMCOST_PUB

Line 110: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;

106: l_record_count NUMBER(10) :=0;
107: l_loop_cnt NUMBER(10) :=0;
108: l_dummy_cnt NUMBER(10) :=0;
109: l_data VARCHAR2(1000);
110: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;
111: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;
112: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;
113: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;
114: l_p_dir VARCHAR2(150);

Line 111: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;

107: l_loop_cnt NUMBER(10) :=0;
108: l_dummy_cnt NUMBER(10) :=0;
109: l_data VARCHAR2(1000);
110: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;
111: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;
112: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;
113: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;
114: l_p_dir VARCHAR2(150);
115: l_output_file VARCHAR2(120);

Line 112: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;

108: l_dummy_cnt NUMBER(10) :=0;
109: l_data VARCHAR2(1000);
110: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;
111: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;
112: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;
113: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;
114: l_p_dir VARCHAR2(150);
115: l_output_file VARCHAR2(120);
116: l_outfile_handle UTL_FILE.FILE_TYPE;

Line 113: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;

109: l_data VARCHAR2(1000);
110: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;
111: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;
112: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;
113: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;
114: l_p_dir VARCHAR2(150);
115: l_output_file VARCHAR2(120);
116: l_outfile_handle UTL_FILE.FILE_TYPE;
117: l_input_file VARCHAR2(120);

Line 321: GMF_ItemCost_PUB.Create_Item_Cost

317: --UTL_FILE.PUT_LINE(l_log_handle, 'Type = ' || l_type) ;
318: EXCEPTION
319: WHEN NO_DATA_FOUND THEN
320: IF l_skip_details = 'N' THEN
321: GMF_ItemCost_PUB.Create_Item_Cost
322: (
323: p_api_version => 3.0,
324: p_init_msg_list => FND_API.G_TRUE,
325: p_commit => FND_API.G_TRUE,

Line 343: GMF_ItemCost_PUB.Create_Item_Cost

339:
340: -- DBMS_OUTPUT.PUT_LINE('Check to call Create_Item_Cost API...type - ' || l_type || ' count = ' || l_record_count);
341: IF (l_type = '10' AND l_record_count <> 1 AND l_skip_details = 'N') THEN
342: -- DBMS_OUTPUT.PUT_LINE('Calling Create_Item_Cost API...');
343: GMF_ItemCost_PUB.Create_Item_Cost
344: (
345: p_api_version => 3.0,
346: p_init_msg_list => FND_API.G_TRUE,
347: p_commit => FND_API.G_TRUE,

Line 559: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;

555: l_record_count NUMBER(10) :=0;
556: l_loop_cnt NUMBER(10) :=0;
557: l_dummy_cnt NUMBER(10) :=0;
558: l_data VARCHAR2(2000);
559: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;
560: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;
561: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;
562: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;
563: l_p_dir VARCHAR2(150);

Line 560: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;

556: l_loop_cnt NUMBER(10) :=0;
557: l_dummy_cnt NUMBER(10) :=0;
558: l_data VARCHAR2(2000);
559: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;
560: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;
561: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;
562: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;
563: l_p_dir VARCHAR2(150);
564: l_output_file VARCHAR2(120);

Line 561: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;

557: l_dummy_cnt NUMBER(10) :=0;
558: l_data VARCHAR2(2000);
559: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;
560: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;
561: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;
562: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;
563: l_p_dir VARCHAR2(150);
564: l_output_file VARCHAR2(120);
565: l_outfile_handle UTL_FILE.FILE_TYPE;

Line 562: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;

558: l_data VARCHAR2(2000);
559: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;
560: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;
561: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;
562: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;
563: l_p_dir VARCHAR2(150);
564: l_output_file VARCHAR2(120);
565: l_outfile_handle UTL_FILE.FILE_TYPE;
566: l_input_file VARCHAR2(120);

Line 786: GMF_ItemCost_PUB.Update_Item_Cost

782: EXCEPTION
783: WHEN NO_DATA_FOUND THEN
784: IF l_skip_details = 'N' THEN
785: -- DBMS_OUTPUT.PUT_LINE('In exception. Calling Update_Item_Cost API...');
786: GMF_ItemCost_PUB.Update_Item_Cost
787: (
788: p_api_version => 3.0,
789: p_init_msg_list => FND_API.G_TRUE,
790: p_commit => FND_API.G_TRUE,

Line 806: GMF_ItemCost_PUB.Update_Item_Cost

802: END;
803: -- DBMS_OUTPUT.PUT_LINE('Check to call Update_Item_Cost API...type - ' || l_type || ' count = ' || l_record_count);
804: IF (l_type = '10' AND l_record_count <> 1 AND l_skip_details = 'N') THEN
805: -- DBMS_OUTPUT.PUT_LINE('Calling Update_Item_Cost API...');
806: GMF_ItemCost_PUB.Update_Item_Cost
807: (
808: p_api_version => 3.0,
809: p_init_msg_list => FND_API.G_TRUE,
810: p_commit => FND_API.G_TRUE,

Line 1006: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;

1002: l_record_count NUMBER(10) :=0;
1003: l_loop_cnt NUMBER(10) :=0;
1004: l_dummy_cnt NUMBER(10) :=0;
1005: l_data VARCHAR2(2000);
1006: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;
1007: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;
1008: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;
1009: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;
1010: l_p_dir VARCHAR2(150);

Line 1007: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;

1003: l_loop_cnt NUMBER(10) :=0;
1004: l_dummy_cnt NUMBER(10) :=0;
1005: l_data VARCHAR2(2000);
1006: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;
1007: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;
1008: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;
1009: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;
1010: l_p_dir VARCHAR2(150);
1011: l_output_file VARCHAR2(120);

Line 1008: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;

1004: l_dummy_cnt NUMBER(10) :=0;
1005: l_data VARCHAR2(2000);
1006: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;
1007: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;
1008: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;
1009: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;
1010: l_p_dir VARCHAR2(150);
1011: l_output_file VARCHAR2(120);
1012: l_outfile_handle UTL_FILE.FILE_TYPE;

Line 1009: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;

1005: l_data VARCHAR2(2000);
1006: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;
1007: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;
1008: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;
1009: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;
1010: l_p_dir VARCHAR2(150);
1011: l_output_file VARCHAR2(120);
1012: l_outfile_handle UTL_FILE.FILE_TYPE;
1013: l_input_file VARCHAR2(120);

Line 1226: GMF_ItemCost_PUB.Delete_Item_Cost

1222: EXCEPTION
1223: WHEN NO_DATA_FOUND THEN
1224: IF l_skip_details = 'N' THEN
1225: -- DBMS_OUTPUT.PUT_LINE('In exception. Calling Delete_Item_Cost API...');
1226: GMF_ItemCost_PUB.Delete_Item_Cost
1227: (
1228: p_api_version => 3.0,
1229: p_init_msg_list => FND_API.G_TRUE,
1230: p_commit => FND_API.G_TRUE,

Line 1246: GMF_ItemCost_PUB.Delete_Item_Cost

1242: END;
1243: -- DBMS_OUTPUT.PUT_LINE('Check to call Delete_Item_Cost API...type - ' || l_type || ' count = ' || l_record_count);
1244: IF (l_type = '10' AND l_record_count <> 1 AND l_skip_details = 'N') THEN
1245: -- DBMS_OUTPUT.PUT_LINE('Calling Delete_Item_Cost API...');
1246: GMF_ItemCost_PUB.Delete_Item_Cost
1247: (
1248: p_api_version => 3.0,
1249: p_init_msg_list => FND_API.G_TRUE,
1250: p_commit => FND_API.G_TRUE,

Line 1449: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;

1445: l_record_count NUMBER(10) :=0;
1446: l_loop_cnt NUMBER(10) :=0;
1447: l_dummy_cnt NUMBER(10) :=0;
1448: l_data VARCHAR2(1000);
1449: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;
1450: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;
1451: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;
1452: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;
1453: l_p_dir VARCHAR2(150);

Line 1450: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;

1446: l_loop_cnt NUMBER(10) :=0;
1447: l_dummy_cnt NUMBER(10) :=0;
1448: l_data VARCHAR2(1000);
1449: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;
1450: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;
1451: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;
1452: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;
1453: l_p_dir VARCHAR2(150);
1454: l_output_file VARCHAR2(120);

Line 1451: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;

1447: l_dummy_cnt NUMBER(10) :=0;
1448: l_data VARCHAR2(1000);
1449: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;
1450: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;
1451: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;
1452: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;
1453: l_p_dir VARCHAR2(150);
1454: l_output_file VARCHAR2(120);
1455: l_outfile_handle UTL_FILE.FILE_TYPE;

Line 1452: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;

1448: l_data VARCHAR2(1000);
1449: l_header_rec GMF_ItemCost_PUB.Header_Rec_Type;
1450: l_this_lvl_tbl GMF_ItemCost_PUB.This_Level_Dtl_Tbl_Type;
1451: l_lower_lvl_tbl GMF_ItemCost_PUB.Lower_Level_Dtl_Tbl_Type;
1452: l_costcmpnt_ids GMF_ItemCost_PUB.costcmpnt_ids_tbl_type;
1453: l_p_dir VARCHAR2(150);
1454: l_output_file VARCHAR2(120);
1455: l_outfile_handle UTL_FILE.FILE_TYPE;
1456: l_input_file VARCHAR2(120);

Line 1546: GMF_ItemCost_PUB.Get_Item_Cost

1542: UTL_FILE.PUT_LINE(l_log_handle, 'inventory_item_id= ' || l_header_rec.inventory_item_id) ;
1543: UTL_FILE.PUT_LINE(l_log_handle, 'item_number = ' || l_header_rec.item_number) ;
1544: UTL_FILE.PUT_LINE(l_log_handle, 'user_name = ' || l_header_rec.user_name) ;
1545: -- DBMS_OUTPUT.PUT_LINE('Calling Get_Item_Cost API...');
1546: GMF_ItemCost_PUB.Get_Item_Cost
1547: (
1548: p_api_version => 3.0,
1549: p_init_msg_list => FND_API.G_TRUE,
1550: x_return_status => l_status,