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.CST_PAC_ITERATION_PROCESS_PVT dependencies on FND_GLOBAL

Line 1914: , FND_GLOBAL.user_id

1910: , user_entered
1911: , insertion_flag
1912: , transaction_costed_date
1913: , SYSDATE
1914: , FND_GLOBAL.user_id
1915: , SYSDATE
1916: , FND_GLOBAL.user_id
1917: , FND_GLOBAL.conc_request_id
1918: , FND_GLOBAL.prog_appl_id

Line 1916: , FND_GLOBAL.user_id

1912: , transaction_costed_date
1913: , SYSDATE
1914: , FND_GLOBAL.user_id
1915: , SYSDATE
1916: , FND_GLOBAL.user_id
1917: , FND_GLOBAL.conc_request_id
1918: , FND_GLOBAL.prog_appl_id
1919: , FND_GLOBAL.conc_program_id
1920: , SYSDATE

Line 1917: , FND_GLOBAL.conc_request_id

1913: , SYSDATE
1914: , FND_GLOBAL.user_id
1915: , SYSDATE
1916: , FND_GLOBAL.user_id
1917: , FND_GLOBAL.conc_request_id
1918: , FND_GLOBAL.prog_appl_id
1919: , FND_GLOBAL.conc_program_id
1920: , SYSDATE
1921: , FND_GLOBAL.login_id

Line 1918: , FND_GLOBAL.prog_appl_id

1914: , FND_GLOBAL.user_id
1915: , SYSDATE
1916: , FND_GLOBAL.user_id
1917: , FND_GLOBAL.conc_request_id
1918: , FND_GLOBAL.prog_appl_id
1919: , FND_GLOBAL.conc_program_id
1920: , SYSDATE
1921: , FND_GLOBAL.login_id
1922: FROM MTL_PAC_ACT_CST_DTL_TEMP mpacdt

Line 1919: , FND_GLOBAL.conc_program_id

1915: , SYSDATE
1916: , FND_GLOBAL.user_id
1917: , FND_GLOBAL.conc_request_id
1918: , FND_GLOBAL.prog_appl_id
1919: , FND_GLOBAL.conc_program_id
1920: , SYSDATE
1921: , FND_GLOBAL.login_id
1922: FROM MTL_PAC_ACT_CST_DTL_TEMP mpacdt
1923: WHERE mpacdt.pac_period_id = p_pac_period_id

Line 1921: , FND_GLOBAL.login_id

1917: , FND_GLOBAL.conc_request_id
1918: , FND_GLOBAL.prog_appl_id
1919: , FND_GLOBAL.conc_program_id
1920: , SYSDATE
1921: , FND_GLOBAL.login_id
1922: FROM MTL_PAC_ACT_CST_DTL_TEMP mpacdt
1923: WHERE mpacdt.pac_period_id = p_pac_period_id
1924: AND mpacdt.inventory_item_id = p_inventory_item_id
1925: AND mpacdt.cost_group_id = nvl(p_cost_group_id, mpacdt.cost_group_id)

Line 2056: ,last_updated_by = FND_GLOBAL.user_id

2052: -- Update cpicd with new cost, new buy cost, new make cost
2053: -- ========================================================
2054: UPDATE cst_pac_item_cost_details cpicd
2055: SET last_update_date = SYSDATE
2056: ,last_updated_by = FND_GLOBAL.user_id
2057: ,last_update_login = FND_GLOBAL.login_id
2058: ,request_id = FND_GLOBAL.conc_request_id
2059: ,program_application_id = FND_GLOBAL.prog_appl_id
2060: ,program_id = FND_GLOBAL.conc_program_id

Line 2057: ,last_update_login = FND_GLOBAL.login_id

2053: -- ========================================================
2054: UPDATE cst_pac_item_cost_details cpicd
2055: SET last_update_date = SYSDATE
2056: ,last_updated_by = FND_GLOBAL.user_id
2057: ,last_update_login = FND_GLOBAL.login_id
2058: ,request_id = FND_GLOBAL.conc_request_id
2059: ,program_application_id = FND_GLOBAL.prog_appl_id
2060: ,program_id = FND_GLOBAL.conc_program_id
2061: ,program_update_date = SYSDATE

Line 2058: ,request_id = FND_GLOBAL.conc_request_id

2054: UPDATE cst_pac_item_cost_details cpicd
2055: SET last_update_date = SYSDATE
2056: ,last_updated_by = FND_GLOBAL.user_id
2057: ,last_update_login = FND_GLOBAL.login_id
2058: ,request_id = FND_GLOBAL.conc_request_id
2059: ,program_application_id = FND_GLOBAL.prog_appl_id
2060: ,program_id = FND_GLOBAL.conc_program_id
2061: ,program_update_date = SYSDATE
2062: ,item_cost = l_item_cost

Line 2059: ,program_application_id = FND_GLOBAL.prog_appl_id

2055: SET last_update_date = SYSDATE
2056: ,last_updated_by = FND_GLOBAL.user_id
2057: ,last_update_login = FND_GLOBAL.login_id
2058: ,request_id = FND_GLOBAL.conc_request_id
2059: ,program_application_id = FND_GLOBAL.prog_appl_id
2060: ,program_id = FND_GLOBAL.conc_program_id
2061: ,program_update_date = SYSDATE
2062: ,item_cost = l_item_cost
2063: ,item_balance = l_item_balance

Line 2060: ,program_id = FND_GLOBAL.conc_program_id

2056: ,last_updated_by = FND_GLOBAL.user_id
2057: ,last_update_login = FND_GLOBAL.login_id
2058: ,request_id = FND_GLOBAL.conc_request_id
2059: ,program_application_id = FND_GLOBAL.prog_appl_id
2060: ,program_id = FND_GLOBAL.conc_program_id
2061: ,program_update_date = SYSDATE
2062: ,item_cost = l_item_cost
2063: ,item_balance = l_item_balance
2064: WHERE cpicd.cost_layer_id = mpacd_idx.cost_layer_id

Line 2091: FND_GLOBAL.user_id,

2087: (SELECT mpacd_idx.cost_layer_id,
2088: mpacd_idx.cost_element_id,
2089: mpacd_idx.level_type,
2090: sysdate,
2091: FND_GLOBAL.user_id,
2092: sysdate,
2093: FND_GLOBAL.user_id,
2094: FND_GLOBAL.login_id,
2095: FND_GLOBAL.conc_request_id,

Line 2093: FND_GLOBAL.user_id,

2089: mpacd_idx.level_type,
2090: sysdate,
2091: FND_GLOBAL.user_id,
2092: sysdate,
2093: FND_GLOBAL.user_id,
2094: FND_GLOBAL.login_id,
2095: FND_GLOBAL.conc_request_id,
2096: FND_GLOBAL.prog_appl_id,
2097: FND_GLOBAL.conc_program_id,

Line 2094: FND_GLOBAL.login_id,

2090: sysdate,
2091: FND_GLOBAL.user_id,
2092: sysdate,
2093: FND_GLOBAL.user_id,
2094: FND_GLOBAL.login_id,
2095: FND_GLOBAL.conc_request_id,
2096: FND_GLOBAL.prog_appl_id,
2097: FND_GLOBAL.conc_program_id,
2098: sysdate,

Line 2095: FND_GLOBAL.conc_request_id,

2091: FND_GLOBAL.user_id,
2092: sysdate,
2093: FND_GLOBAL.user_id,
2094: FND_GLOBAL.login_id,
2095: FND_GLOBAL.conc_request_id,
2096: FND_GLOBAL.prog_appl_id,
2097: FND_GLOBAL.conc_program_id,
2098: sysdate,
2099: l_item_cost,

Line 2096: FND_GLOBAL.prog_appl_id,

2092: sysdate,
2093: FND_GLOBAL.user_id,
2094: FND_GLOBAL.login_id,
2095: FND_GLOBAL.conc_request_id,
2096: FND_GLOBAL.prog_appl_id,
2097: FND_GLOBAL.conc_program_id,
2098: sysdate,
2099: l_item_cost,
2100: 0,

Line 2097: FND_GLOBAL.conc_program_id,

2093: FND_GLOBAL.user_id,
2094: FND_GLOBAL.login_id,
2095: FND_GLOBAL.conc_request_id,
2096: FND_GLOBAL.prog_appl_id,
2097: FND_GLOBAL.conc_program_id,
2098: sysdate,
2099: l_item_cost,
2100: 0,
2101: 0,

Line 2147: FND_GLOBAL.user_id

2143: ,unburdened_cost
2144: ,burden_cost
2145: ) =
2146: (SELECT
2147: FND_GLOBAL.user_id
2148: , SYSDATE
2149: , FND_GLOBAL.login_id
2150: , FND_GLOBAL.conc_request_id
2151: , FND_GLOBAL.prog_appl_id

Line 2149: , FND_GLOBAL.login_id

2145: ) =
2146: (SELECT
2147: FND_GLOBAL.user_id
2148: , SYSDATE
2149: , FND_GLOBAL.login_id
2150: , FND_GLOBAL.conc_request_id
2151: , FND_GLOBAL.prog_appl_id
2152: , FND_GLOBAL.conc_program_id
2153: , SYSDATE

Line 2150: , FND_GLOBAL.conc_request_id

2146: (SELECT
2147: FND_GLOBAL.user_id
2148: , SYSDATE
2149: , FND_GLOBAL.login_id
2150: , FND_GLOBAL.conc_request_id
2151: , FND_GLOBAL.prog_appl_id
2152: , FND_GLOBAL.conc_program_id
2153: , SYSDATE
2154: , SUM(DECODE(level_type,2,DECODE(cost_element_id,1,item_cost,0),0))

Line 2151: , FND_GLOBAL.prog_appl_id

2147: FND_GLOBAL.user_id
2148: , SYSDATE
2149: , FND_GLOBAL.login_id
2150: , FND_GLOBAL.conc_request_id
2151: , FND_GLOBAL.prog_appl_id
2152: , FND_GLOBAL.conc_program_id
2153: , SYSDATE
2154: , SUM(DECODE(level_type,2,DECODE(cost_element_id,1,item_cost,0),0))
2155: , SUM(DECODE(level_type,2,DECODE(cost_element_id,2,item_cost,0),0))

Line 2152: , FND_GLOBAL.conc_program_id

2148: , SYSDATE
2149: , FND_GLOBAL.login_id
2150: , FND_GLOBAL.conc_request_id
2151: , FND_GLOBAL.prog_appl_id
2152: , FND_GLOBAL.conc_program_id
2153: , SYSDATE
2154: , SUM(DECODE(level_type,2,DECODE(cost_element_id,1,item_cost,0),0))
2155: , SUM(DECODE(level_type,2,DECODE(cost_element_id,2,item_cost,0),0))
2156: , SUM(DECODE(level_type,2,DECODE(cost_element_id,3,item_cost,0),0))

Line 2201: ,p_user_id => FND_GLOBAL.user_id

2197: ,p_cost_type_id => p_cost_type_id
2198: ,p_cost_group_id => p_cost_group_id
2199: ,p_inventory_item_id => p_inventory_item_id
2200: ,p_end_date => p_end_date
2201: ,p_user_id => FND_GLOBAL.user_id
2202: ,p_login_id => FND_GLOBAL.login_id
2203: ,p_req_id => FND_GLOBAL.conc_request_id
2204: ,p_prg_id => FND_GLOBAL.conc_program_id
2205: ,p_prg_appid => FND_GLOBAL.prog_appl_id

Line 2202: ,p_login_id => FND_GLOBAL.login_id

2198: ,p_cost_group_id => p_cost_group_id
2199: ,p_inventory_item_id => p_inventory_item_id
2200: ,p_end_date => p_end_date
2201: ,p_user_id => FND_GLOBAL.user_id
2202: ,p_login_id => FND_GLOBAL.login_id
2203: ,p_req_id => FND_GLOBAL.conc_request_id
2204: ,p_prg_id => FND_GLOBAL.conc_program_id
2205: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2206: );

Line 2203: ,p_req_id => FND_GLOBAL.conc_request_id

2199: ,p_inventory_item_id => p_inventory_item_id
2200: ,p_end_date => p_end_date
2201: ,p_user_id => FND_GLOBAL.user_id
2202: ,p_login_id => FND_GLOBAL.login_id
2203: ,p_req_id => FND_GLOBAL.conc_request_id
2204: ,p_prg_id => FND_GLOBAL.conc_program_id
2205: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2206: );
2207: ELSE

Line 2204: ,p_prg_id => FND_GLOBAL.conc_program_id

2200: ,p_end_date => p_end_date
2201: ,p_user_id => FND_GLOBAL.user_id
2202: ,p_login_id => FND_GLOBAL.login_id
2203: ,p_req_id => FND_GLOBAL.conc_request_id
2204: ,p_prg_id => FND_GLOBAL.conc_program_id
2205: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2206: );
2207: ELSE
2208: FOR cost_group_idx IN cost_group_cur(p_inventory_item_id

Line 2205: ,p_prg_appid => FND_GLOBAL.prog_appl_id

2201: ,p_user_id => FND_GLOBAL.user_id
2202: ,p_login_id => FND_GLOBAL.login_id
2203: ,p_req_id => FND_GLOBAL.conc_request_id
2204: ,p_prg_id => FND_GLOBAL.conc_program_id
2205: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2206: );
2207: ELSE
2208: FOR cost_group_idx IN cost_group_cur(p_inventory_item_id
2209: ,p_pac_period_id)

Line 2216: ,p_user_id => FND_GLOBAL.user_id

2212: ,p_cost_type_id => p_cost_type_id
2213: ,p_cost_group_id => cost_group_idx.cost_group_id
2214: ,p_inventory_item_id => p_inventory_item_id
2215: ,p_end_date => p_end_date
2216: ,p_user_id => FND_GLOBAL.user_id
2217: ,p_login_id => FND_GLOBAL.login_id
2218: ,p_req_id => FND_GLOBAL.conc_request_id
2219: ,p_prg_id => FND_GLOBAL.conc_program_id
2220: ,p_prg_appid => FND_GLOBAL.prog_appl_id

Line 2217: ,p_login_id => FND_GLOBAL.login_id

2213: ,p_cost_group_id => cost_group_idx.cost_group_id
2214: ,p_inventory_item_id => p_inventory_item_id
2215: ,p_end_date => p_end_date
2216: ,p_user_id => FND_GLOBAL.user_id
2217: ,p_login_id => FND_GLOBAL.login_id
2218: ,p_req_id => FND_GLOBAL.conc_request_id
2219: ,p_prg_id => FND_GLOBAL.conc_program_id
2220: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2221: );

Line 2218: ,p_req_id => FND_GLOBAL.conc_request_id

2214: ,p_inventory_item_id => p_inventory_item_id
2215: ,p_end_date => p_end_date
2216: ,p_user_id => FND_GLOBAL.user_id
2217: ,p_login_id => FND_GLOBAL.login_id
2218: ,p_req_id => FND_GLOBAL.conc_request_id
2219: ,p_prg_id => FND_GLOBAL.conc_program_id
2220: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2221: );
2222: END LOOP;

Line 2219: ,p_prg_id => FND_GLOBAL.conc_program_id

2215: ,p_end_date => p_end_date
2216: ,p_user_id => FND_GLOBAL.user_id
2217: ,p_login_id => FND_GLOBAL.login_id
2218: ,p_req_id => FND_GLOBAL.conc_request_id
2219: ,p_prg_id => FND_GLOBAL.conc_program_id
2220: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2221: );
2222: END LOOP;
2223: END IF;

Line 2220: ,p_prg_appid => FND_GLOBAL.prog_appl_id

2216: ,p_user_id => FND_GLOBAL.user_id
2217: ,p_login_id => FND_GLOBAL.login_id
2218: ,p_req_id => FND_GLOBAL.conc_request_id
2219: ,p_prg_id => FND_GLOBAL.conc_program_id
2220: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2221: );
2222: END LOOP;
2223: END IF;
2224: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2304: ,last_updated_by = FND_GLOBAL.user_id

2300: SET process_status = p_phase_status
2301: ,process_date = SYSDATE
2302: ,process_upto_date = decode(p_phase_status,4,p_period_end_date,NULL)
2303: ,last_update_date = SYSDATE
2304: ,last_updated_by = FND_GLOBAL.user_id
2305: ,request_id = FND_GLOBAL.conc_request_id
2306: ,program_application_id = FND_GLOBAL.prog_appl_id
2307: ,program_id = FND_GLOBAL.conc_program_id
2308: ,program_update_date = SYSDATE

Line 2305: ,request_id = FND_GLOBAL.conc_request_id

2301: ,process_date = SYSDATE
2302: ,process_upto_date = decode(p_phase_status,4,p_period_end_date,NULL)
2303: ,last_update_date = SYSDATE
2304: ,last_updated_by = FND_GLOBAL.user_id
2305: ,request_id = FND_GLOBAL.conc_request_id
2306: ,program_application_id = FND_GLOBAL.prog_appl_id
2307: ,program_id = FND_GLOBAL.conc_program_id
2308: ,program_update_date = SYSDATE
2309: ,last_update_login = FND_GLOBAL.login_id

Line 2306: ,program_application_id = FND_GLOBAL.prog_appl_id

2302: ,process_upto_date = decode(p_phase_status,4,p_period_end_date,NULL)
2303: ,last_update_date = SYSDATE
2304: ,last_updated_by = FND_GLOBAL.user_id
2305: ,request_id = FND_GLOBAL.conc_request_id
2306: ,program_application_id = FND_GLOBAL.prog_appl_id
2307: ,program_id = FND_GLOBAL.conc_program_id
2308: ,program_update_date = SYSDATE
2309: ,last_update_login = FND_GLOBAL.login_id
2310: WHERE pac_period_id = p_period_id

Line 2307: ,program_id = FND_GLOBAL.conc_program_id

2303: ,last_update_date = SYSDATE
2304: ,last_updated_by = FND_GLOBAL.user_id
2305: ,request_id = FND_GLOBAL.conc_request_id
2306: ,program_application_id = FND_GLOBAL.prog_appl_id
2307: ,program_id = FND_GLOBAL.conc_program_id
2308: ,program_update_date = SYSDATE
2309: ,last_update_login = FND_GLOBAL.login_id
2310: WHERE pac_period_id = p_period_id
2311: AND cost_group_id = l_cost_group_id

Line 2309: ,last_update_login = FND_GLOBAL.login_id

2305: ,request_id = FND_GLOBAL.conc_request_id
2306: ,program_application_id = FND_GLOBAL.prog_appl_id
2307: ,program_id = FND_GLOBAL.conc_program_id
2308: ,program_update_date = SYSDATE
2309: ,last_update_login = FND_GLOBAL.login_id
2310: WHERE pac_period_id = p_period_id
2311: AND cost_group_id = l_cost_group_id
2312: AND process_phase = 5;
2313:

Line 2425: ,last_updated_by = FND_GLOBAL.user_id

2421: ,process_upto_date = decode(p_phase_status,4,p_period_end_date,
2422: 5,p_period_end_date,
2423: 3,p_period_end_date,NULL)
2424: ,last_update_date = SYSDATE
2425: ,last_updated_by = FND_GLOBAL.user_id
2426: ,request_id = FND_GLOBAL.conc_request_id
2427: ,program_application_id = FND_GLOBAL.prog_appl_id
2428: ,program_id = FND_GLOBAL.conc_program_id
2429: ,program_update_date = SYSDATE

Line 2426: ,request_id = FND_GLOBAL.conc_request_id

2422: 5,p_period_end_date,
2423: 3,p_period_end_date,NULL)
2424: ,last_update_date = SYSDATE
2425: ,last_updated_by = FND_GLOBAL.user_id
2426: ,request_id = FND_GLOBAL.conc_request_id
2427: ,program_application_id = FND_GLOBAL.prog_appl_id
2428: ,program_id = FND_GLOBAL.conc_program_id
2429: ,program_update_date = SYSDATE
2430: ,last_update_login = FND_GLOBAL.login_id

Line 2427: ,program_application_id = FND_GLOBAL.prog_appl_id

2423: 3,p_period_end_date,NULL)
2424: ,last_update_date = SYSDATE
2425: ,last_updated_by = FND_GLOBAL.user_id
2426: ,request_id = FND_GLOBAL.conc_request_id
2427: ,program_application_id = FND_GLOBAL.prog_appl_id
2428: ,program_id = FND_GLOBAL.conc_program_id
2429: ,program_update_date = SYSDATE
2430: ,last_update_login = FND_GLOBAL.login_id
2431: WHERE pac_period_id = p_period_id

Line 2428: ,program_id = FND_GLOBAL.conc_program_id

2424: ,last_update_date = SYSDATE
2425: ,last_updated_by = FND_GLOBAL.user_id
2426: ,request_id = FND_GLOBAL.conc_request_id
2427: ,program_application_id = FND_GLOBAL.prog_appl_id
2428: ,program_id = FND_GLOBAL.conc_program_id
2429: ,program_update_date = SYSDATE
2430: ,last_update_login = FND_GLOBAL.login_id
2431: WHERE pac_period_id = p_period_id
2432: AND cost_group_id = l_cost_group_id

Line 2430: ,last_update_login = FND_GLOBAL.login_id

2426: ,request_id = FND_GLOBAL.conc_request_id
2427: ,program_application_id = FND_GLOBAL.prog_appl_id
2428: ,program_id = FND_GLOBAL.conc_program_id
2429: ,program_update_date = SYSDATE
2430: ,last_update_login = FND_GLOBAL.login_id
2431: WHERE pac_period_id = p_period_id
2432: AND cost_group_id = l_cost_group_id
2433: AND process_phase = 7;
2434:

Line 3819: ,i_user_id => FND_GLOBAL.user_id

3815: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000) THEN
3816: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
3817: ,i_cost_group_id => p_cost_group_id
3818: ,i_txn_category => l_txn_category
3819: ,i_user_id => FND_GLOBAL.user_id
3820: ,i_login_id => FND_GLOBAL.login_id
3821: ,i_request_id => FND_GLOBAL.conc_request_id
3822: ,i_prog_id => FND_GLOBAL.conc_program_id
3823: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id

Line 3820: ,i_login_id => FND_GLOBAL.login_id

3816: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
3817: ,i_cost_group_id => p_cost_group_id
3818: ,i_txn_category => l_txn_category
3819: ,i_user_id => FND_GLOBAL.user_id
3820: ,i_login_id => FND_GLOBAL.login_id
3821: ,i_request_id => FND_GLOBAL.conc_request_id
3822: ,i_prog_id => FND_GLOBAL.conc_program_id
3823: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
3824: ,o_err_num => l_error_num

Line 3821: ,i_request_id => FND_GLOBAL.conc_request_id

3817: ,i_cost_group_id => p_cost_group_id
3818: ,i_txn_category => l_txn_category
3819: ,i_user_id => FND_GLOBAL.user_id
3820: ,i_login_id => FND_GLOBAL.login_id
3821: ,i_request_id => FND_GLOBAL.conc_request_id
3822: ,i_prog_id => FND_GLOBAL.conc_program_id
3823: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
3824: ,o_err_num => l_error_num
3825: ,o_err_code => l_error_code

Line 3822: ,i_prog_id => FND_GLOBAL.conc_program_id

3818: ,i_txn_category => l_txn_category
3819: ,i_user_id => FND_GLOBAL.user_id
3820: ,i_login_id => FND_GLOBAL.login_id
3821: ,i_request_id => FND_GLOBAL.conc_request_id
3822: ,i_prog_id => FND_GLOBAL.conc_program_id
3823: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
3824: ,o_err_num => l_error_num
3825: ,o_err_code => l_error_code
3826: ,o_err_msg => l_error_msg

Line 3823: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id

3819: ,i_user_id => FND_GLOBAL.user_id
3820: ,i_login_id => FND_GLOBAL.login_id
3821: ,i_request_id => FND_GLOBAL.conc_request_id
3822: ,i_prog_id => FND_GLOBAL.conc_program_id
3823: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
3824: ,o_err_num => l_error_num
3825: ,o_err_code => l_error_code
3826: ,o_err_msg => l_error_msg
3827: );

Line 3858: , i_user_id => FND_GLOBAL.user_id

3854: , i_pac_rates_id => p_pac_rates_id
3855: , i_process_group => 1
3856: , i_master_org_id => p_master_org_id
3857: , i_uom_control => p_uom_control
3858: , i_user_id => FND_GLOBAL.user_id
3859: , i_login_id => FND_GLOBAL.login_id
3860: , i_request_id => FND_GLOBAL.conc_request_id
3861: , i_prog_id => FND_GLOBAL.conc_program_id
3862: , i_prog_appl_id => FND_GLOBAL.prog_appl_id

Line 3859: , i_login_id => FND_GLOBAL.login_id

3855: , i_process_group => 1
3856: , i_master_org_id => p_master_org_id
3857: , i_uom_control => p_uom_control
3858: , i_user_id => FND_GLOBAL.user_id
3859: , i_login_id => FND_GLOBAL.login_id
3860: , i_request_id => FND_GLOBAL.conc_request_id
3861: , i_prog_id => FND_GLOBAL.conc_program_id
3862: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
3863: , i_txn_category => l_txn_category

Line 3860: , i_request_id => FND_GLOBAL.conc_request_id

3856: , i_master_org_id => p_master_org_id
3857: , i_uom_control => p_uom_control
3858: , i_user_id => FND_GLOBAL.user_id
3859: , i_login_id => FND_GLOBAL.login_id
3860: , i_request_id => FND_GLOBAL.conc_request_id
3861: , i_prog_id => FND_GLOBAL.conc_program_id
3862: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
3863: , i_txn_category => l_txn_category
3864: , i_transfer_price_pd => l_group1_interorg_tab(i).transfer_price

Line 3861: , i_prog_id => FND_GLOBAL.conc_program_id

3857: , i_uom_control => p_uom_control
3858: , i_user_id => FND_GLOBAL.user_id
3859: , i_login_id => FND_GLOBAL.login_id
3860: , i_request_id => FND_GLOBAL.conc_request_id
3861: , i_prog_id => FND_GLOBAL.conc_program_id
3862: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
3863: , i_txn_category => l_txn_category
3864: , i_transfer_price_pd => l_group1_interorg_tab(i).transfer_price
3865: , o_err_num => l_error_num

Line 3862: , i_prog_appl_id => FND_GLOBAL.prog_appl_id

3858: , i_user_id => FND_GLOBAL.user_id
3859: , i_login_id => FND_GLOBAL.login_id
3860: , i_request_id => FND_GLOBAL.conc_request_id
3861: , i_prog_id => FND_GLOBAL.conc_program_id
3862: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
3863: , i_txn_category => l_txn_category
3864: , i_transfer_price_pd => l_group1_interorg_tab(i).transfer_price
3865: , o_err_num => l_error_num
3866: , o_err_code => l_error_code

Line 4045: ,i_user_id => FND_GLOBAL.user_id

4041: IF (CSTPPINV.l_item_id_tbl.COUNT > 0) THEN
4042: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4043: ,i_cost_group_id => p_cost_group_id
4044: ,i_txn_category => l_txn_category
4045: ,i_user_id => FND_GLOBAL.user_id
4046: ,i_login_id => FND_GLOBAL.login_id
4047: ,i_request_id => FND_GLOBAL.conc_request_id
4048: ,i_prog_id => FND_GLOBAL.conc_program_id
4049: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id

Line 4046: ,i_login_id => FND_GLOBAL.login_id

4042: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4043: ,i_cost_group_id => p_cost_group_id
4044: ,i_txn_category => l_txn_category
4045: ,i_user_id => FND_GLOBAL.user_id
4046: ,i_login_id => FND_GLOBAL.login_id
4047: ,i_request_id => FND_GLOBAL.conc_request_id
4048: ,i_prog_id => FND_GLOBAL.conc_program_id
4049: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4050: ,o_err_num => l_error_num

Line 4047: ,i_request_id => FND_GLOBAL.conc_request_id

4043: ,i_cost_group_id => p_cost_group_id
4044: ,i_txn_category => l_txn_category
4045: ,i_user_id => FND_GLOBAL.user_id
4046: ,i_login_id => FND_GLOBAL.login_id
4047: ,i_request_id => FND_GLOBAL.conc_request_id
4048: ,i_prog_id => FND_GLOBAL.conc_program_id
4049: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4050: ,o_err_num => l_error_num
4051: ,o_err_code => l_error_code

Line 4048: ,i_prog_id => FND_GLOBAL.conc_program_id

4044: ,i_txn_category => l_txn_category
4045: ,i_user_id => FND_GLOBAL.user_id
4046: ,i_login_id => FND_GLOBAL.login_id
4047: ,i_request_id => FND_GLOBAL.conc_request_id
4048: ,i_prog_id => FND_GLOBAL.conc_program_id
4049: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4050: ,o_err_num => l_error_num
4051: ,o_err_code => l_error_code
4052: ,o_err_msg => l_error_msg

Line 4049: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id

4045: ,i_user_id => FND_GLOBAL.user_id
4046: ,i_login_id => FND_GLOBAL.login_id
4047: ,i_request_id => FND_GLOBAL.conc_request_id
4048: ,i_prog_id => FND_GLOBAL.conc_program_id
4049: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4050: ,o_err_num => l_error_num
4051: ,o_err_code => l_error_code
4052: ,o_err_msg => l_error_msg
4053: );

Line 4081: ,i_user_id => FND_GLOBAL.user_id

4077: ,i_cost_group_id => p_cost_group_id
4078: ,i_cost_type_id => p_cost_type_id
4079: ,i_low_level_code => p_low_level_code
4080: ,i_item_id => p_inventory_item_id
4081: ,i_user_id => FND_GLOBAL.user_id
4082: ,i_login_id => FND_GLOBAL.login_id
4083: ,i_request_id => FND_GLOBAL.conc_request_id
4084: ,i_prog_id => FND_GLOBAL.conc_program_id
4085: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id

Line 4082: ,i_login_id => FND_GLOBAL.login_id

4078: ,i_cost_type_id => p_cost_type_id
4079: ,i_low_level_code => p_low_level_code
4080: ,i_item_id => p_inventory_item_id
4081: ,i_user_id => FND_GLOBAL.user_id
4082: ,i_login_id => FND_GLOBAL.login_id
4083: ,i_request_id => FND_GLOBAL.conc_request_id
4084: ,i_prog_id => FND_GLOBAL.conc_program_id
4085: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4086: ,o_err_num => l_error_num

Line 4083: ,i_request_id => FND_GLOBAL.conc_request_id

4079: ,i_low_level_code => p_low_level_code
4080: ,i_item_id => p_inventory_item_id
4081: ,i_user_id => FND_GLOBAL.user_id
4082: ,i_login_id => FND_GLOBAL.login_id
4083: ,i_request_id => FND_GLOBAL.conc_request_id
4084: ,i_prog_id => FND_GLOBAL.conc_program_id
4085: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4086: ,o_err_num => l_error_num
4087: ,o_err_code => l_error_code

Line 4084: ,i_prog_id => FND_GLOBAL.conc_program_id

4080: ,i_item_id => p_inventory_item_id
4081: ,i_user_id => FND_GLOBAL.user_id
4082: ,i_login_id => FND_GLOBAL.login_id
4083: ,i_request_id => FND_GLOBAL.conc_request_id
4084: ,i_prog_id => FND_GLOBAL.conc_program_id
4085: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4086: ,o_err_num => l_error_num
4087: ,o_err_code => l_error_code
4088: ,o_err_msg => l_error_msg

Line 4085: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id

4081: ,i_user_id => FND_GLOBAL.user_id
4082: ,i_login_id => FND_GLOBAL.login_id
4083: ,i_request_id => FND_GLOBAL.conc_request_id
4084: ,i_prog_id => FND_GLOBAL.conc_program_id
4085: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4086: ,o_err_num => l_error_num
4087: ,o_err_code => l_error_code
4088: ,o_err_msg => l_error_msg
4089: );

Line 4143: i_user_id => FND_GLOBAL.user_id,

4139: CSTPPWAC.update_item_cppb (i_pac_period_id => p_period_id,
4140: i_cost_group_id => p_cost_group_id,
4141: i_txn_category => l_txn_category,
4142: i_item_id => p_inventory_item_id,
4143: i_user_id => FND_GLOBAL.user_id,
4144: i_login_id => FND_GLOBAL.login_id,
4145: i_request_id => FND_GLOBAL.conc_request_id,
4146: i_prog_id => FND_GLOBAL.conc_program_id,
4147: i_prog_appl_id => FND_GLOBAL.prog_appl_id,

Line 4144: i_login_id => FND_GLOBAL.login_id,

4140: i_cost_group_id => p_cost_group_id,
4141: i_txn_category => l_txn_category,
4142: i_item_id => p_inventory_item_id,
4143: i_user_id => FND_GLOBAL.user_id,
4144: i_login_id => FND_GLOBAL.login_id,
4145: i_request_id => FND_GLOBAL.conc_request_id,
4146: i_prog_id => FND_GLOBAL.conc_program_id,
4147: i_prog_appl_id => FND_GLOBAL.prog_appl_id,
4148: o_err_num => l_error_num,

Line 4145: i_request_id => FND_GLOBAL.conc_request_id,

4141: i_txn_category => l_txn_category,
4142: i_item_id => p_inventory_item_id,
4143: i_user_id => FND_GLOBAL.user_id,
4144: i_login_id => FND_GLOBAL.login_id,
4145: i_request_id => FND_GLOBAL.conc_request_id,
4146: i_prog_id => FND_GLOBAL.conc_program_id,
4147: i_prog_appl_id => FND_GLOBAL.prog_appl_id,
4148: o_err_num => l_error_num,
4149: o_err_code => l_error_code,

Line 4146: i_prog_id => FND_GLOBAL.conc_program_id,

4142: i_item_id => p_inventory_item_id,
4143: i_user_id => FND_GLOBAL.user_id,
4144: i_login_id => FND_GLOBAL.login_id,
4145: i_request_id => FND_GLOBAL.conc_request_id,
4146: i_prog_id => FND_GLOBAL.conc_program_id,
4147: i_prog_appl_id => FND_GLOBAL.prog_appl_id,
4148: o_err_num => l_error_num,
4149: o_err_code => l_error_code,
4150: o_err_msg => l_error_msg );

Line 4147: i_prog_appl_id => FND_GLOBAL.prog_appl_id,

4143: i_user_id => FND_GLOBAL.user_id,
4144: i_login_id => FND_GLOBAL.login_id,
4145: i_request_id => FND_GLOBAL.conc_request_id,
4146: i_prog_id => FND_GLOBAL.conc_program_id,
4147: i_prog_appl_id => FND_GLOBAL.prog_appl_id,
4148: o_err_num => l_error_num,
4149: o_err_code => l_error_code,
4150: o_err_msg => l_error_msg );
4151:

Line 4292: ,i_user_id => FND_GLOBAL.user_id

4288: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000) THEN
4289: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4290: ,i_cost_group_id => p_cost_group_id
4291: ,i_txn_category => l_txn_category
4292: ,i_user_id => FND_GLOBAL.user_id
4293: ,i_login_id => FND_GLOBAL.login_id
4294: ,i_request_id => FND_GLOBAL.conc_request_id
4295: ,i_prog_id => FND_GLOBAL.conc_program_id
4296: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id

Line 4293: ,i_login_id => FND_GLOBAL.login_id

4289: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4290: ,i_cost_group_id => p_cost_group_id
4291: ,i_txn_category => l_txn_category
4292: ,i_user_id => FND_GLOBAL.user_id
4293: ,i_login_id => FND_GLOBAL.login_id
4294: ,i_request_id => FND_GLOBAL.conc_request_id
4295: ,i_prog_id => FND_GLOBAL.conc_program_id
4296: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4297: ,o_err_num => l_error_num

Line 4294: ,i_request_id => FND_GLOBAL.conc_request_id

4290: ,i_cost_group_id => p_cost_group_id
4291: ,i_txn_category => l_txn_category
4292: ,i_user_id => FND_GLOBAL.user_id
4293: ,i_login_id => FND_GLOBAL.login_id
4294: ,i_request_id => FND_GLOBAL.conc_request_id
4295: ,i_prog_id => FND_GLOBAL.conc_program_id
4296: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4297: ,o_err_num => l_error_num
4298: ,o_err_code => l_error_code

Line 4295: ,i_prog_id => FND_GLOBAL.conc_program_id

4291: ,i_txn_category => l_txn_category
4292: ,i_user_id => FND_GLOBAL.user_id
4293: ,i_login_id => FND_GLOBAL.login_id
4294: ,i_request_id => FND_GLOBAL.conc_request_id
4295: ,i_prog_id => FND_GLOBAL.conc_program_id
4296: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4297: ,o_err_num => l_error_num
4298: ,o_err_code => l_error_code
4299: ,o_err_msg => l_error_msg

Line 4296: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id

4292: ,i_user_id => FND_GLOBAL.user_id
4293: ,i_login_id => FND_GLOBAL.login_id
4294: ,i_request_id => FND_GLOBAL.conc_request_id
4295: ,i_prog_id => FND_GLOBAL.conc_program_id
4296: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4297: ,o_err_num => l_error_num
4298: ,o_err_code => l_error_code
4299: ,o_err_msg => l_error_msg
4300: );

Line 4331: , i_user_id => FND_GLOBAL.user_id

4327: , i_pac_rates_id => p_pac_rates_id
4328: , i_process_group => 2
4329: , i_master_org_id => p_master_org_id
4330: , i_uom_control => p_uom_control
4331: , i_user_id => FND_GLOBAL.user_id
4332: , i_login_id => FND_GLOBAL.login_id
4333: , i_request_id => FND_GLOBAL.conc_request_id
4334: , i_prog_id => FND_GLOBAL.conc_program_id
4335: , i_prog_appl_id => FND_GLOBAL.prog_appl_id

Line 4332: , i_login_id => FND_GLOBAL.login_id

4328: , i_process_group => 2
4329: , i_master_org_id => p_master_org_id
4330: , i_uom_control => p_uom_control
4331: , i_user_id => FND_GLOBAL.user_id
4332: , i_login_id => FND_GLOBAL.login_id
4333: , i_request_id => FND_GLOBAL.conc_request_id
4334: , i_prog_id => FND_GLOBAL.conc_program_id
4335: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
4336: , i_txn_category => l_txn_category

Line 4333: , i_request_id => FND_GLOBAL.conc_request_id

4329: , i_master_org_id => p_master_org_id
4330: , i_uom_control => p_uom_control
4331: , i_user_id => FND_GLOBAL.user_id
4332: , i_login_id => FND_GLOBAL.login_id
4333: , i_request_id => FND_GLOBAL.conc_request_id
4334: , i_prog_id => FND_GLOBAL.conc_program_id
4335: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
4336: , i_txn_category => l_txn_category
4337: , i_transfer_price_pd => l_group2_interorg_tab(i).transfer_price

Line 4334: , i_prog_id => FND_GLOBAL.conc_program_id

4330: , i_uom_control => p_uom_control
4331: , i_user_id => FND_GLOBAL.user_id
4332: , i_login_id => FND_GLOBAL.login_id
4333: , i_request_id => FND_GLOBAL.conc_request_id
4334: , i_prog_id => FND_GLOBAL.conc_program_id
4335: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
4336: , i_txn_category => l_txn_category
4337: , i_transfer_price_pd => l_group2_interorg_tab(i).transfer_price
4338: , o_err_num => l_error_num

Line 4335: , i_prog_appl_id => FND_GLOBAL.prog_appl_id

4331: , i_user_id => FND_GLOBAL.user_id
4332: , i_login_id => FND_GLOBAL.login_id
4333: , i_request_id => FND_GLOBAL.conc_request_id
4334: , i_prog_id => FND_GLOBAL.conc_program_id
4335: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
4336: , i_txn_category => l_txn_category
4337: , i_transfer_price_pd => l_group2_interorg_tab(i).transfer_price
4338: , o_err_num => l_error_num
4339: , o_err_code => l_error_code

Line 4510: ,i_user_id => FND_GLOBAL.user_id

4506: IF (CSTPPINV.l_item_id_tbl.COUNT > 0) THEN
4507: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4508: ,i_cost_group_id => p_cost_group_id
4509: ,i_txn_category => l_txn_category
4510: ,i_user_id => FND_GLOBAL.user_id
4511: ,i_login_id => FND_GLOBAL.login_id
4512: ,i_request_id => FND_GLOBAL.conc_request_id
4513: ,i_prog_id => FND_GLOBAL.conc_program_id
4514: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id

Line 4511: ,i_login_id => FND_GLOBAL.login_id

4507: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4508: ,i_cost_group_id => p_cost_group_id
4509: ,i_txn_category => l_txn_category
4510: ,i_user_id => FND_GLOBAL.user_id
4511: ,i_login_id => FND_GLOBAL.login_id
4512: ,i_request_id => FND_GLOBAL.conc_request_id
4513: ,i_prog_id => FND_GLOBAL.conc_program_id
4514: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4515: ,o_err_num => l_error_num

Line 4512: ,i_request_id => FND_GLOBAL.conc_request_id

4508: ,i_cost_group_id => p_cost_group_id
4509: ,i_txn_category => l_txn_category
4510: ,i_user_id => FND_GLOBAL.user_id
4511: ,i_login_id => FND_GLOBAL.login_id
4512: ,i_request_id => FND_GLOBAL.conc_request_id
4513: ,i_prog_id => FND_GLOBAL.conc_program_id
4514: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4515: ,o_err_num => l_error_num
4516: ,o_err_code => l_error_code

Line 4513: ,i_prog_id => FND_GLOBAL.conc_program_id

4509: ,i_txn_category => l_txn_category
4510: ,i_user_id => FND_GLOBAL.user_id
4511: ,i_login_id => FND_GLOBAL.login_id
4512: ,i_request_id => FND_GLOBAL.conc_request_id
4513: ,i_prog_id => FND_GLOBAL.conc_program_id
4514: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4515: ,o_err_num => l_error_num
4516: ,o_err_code => l_error_code
4517: ,o_err_msg => l_error_msg

Line 4514: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id

4510: ,i_user_id => FND_GLOBAL.user_id
4511: ,i_login_id => FND_GLOBAL.login_id
4512: ,i_request_id => FND_GLOBAL.conc_request_id
4513: ,i_prog_id => FND_GLOBAL.conc_program_id
4514: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4515: ,o_err_num => l_error_num
4516: ,o_err_code => l_error_code
4517: ,o_err_msg => l_error_msg
4518: );

Line 4537: ,i_user_id => FND_GLOBAL.user_id

4533: CSTPPWAC.update_item_cppb(i_pac_period_id => p_period_id
4534: ,i_cost_group_id => p_cost_group_id
4535: ,i_txn_category => l_txn_category
4536: ,i_item_id => p_inventory_item_id
4537: ,i_user_id => FND_GLOBAL.user_id
4538: ,i_login_id => FND_GLOBAL.login_id
4539: ,i_request_id => FND_GLOBAL.conc_request_id
4540: ,i_prog_id => FND_GLOBAL.conc_program_id
4541: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id

Line 4538: ,i_login_id => FND_GLOBAL.login_id

4534: ,i_cost_group_id => p_cost_group_id
4535: ,i_txn_category => l_txn_category
4536: ,i_item_id => p_inventory_item_id
4537: ,i_user_id => FND_GLOBAL.user_id
4538: ,i_login_id => FND_GLOBAL.login_id
4539: ,i_request_id => FND_GLOBAL.conc_request_id
4540: ,i_prog_id => FND_GLOBAL.conc_program_id
4541: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4542: ,o_err_num => l_error_num

Line 4539: ,i_request_id => FND_GLOBAL.conc_request_id

4535: ,i_txn_category => l_txn_category
4536: ,i_item_id => p_inventory_item_id
4537: ,i_user_id => FND_GLOBAL.user_id
4538: ,i_login_id => FND_GLOBAL.login_id
4539: ,i_request_id => FND_GLOBAL.conc_request_id
4540: ,i_prog_id => FND_GLOBAL.conc_program_id
4541: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4542: ,o_err_num => l_error_num
4543: ,o_err_code => l_error_code

Line 4540: ,i_prog_id => FND_GLOBAL.conc_program_id

4536: ,i_item_id => p_inventory_item_id
4537: ,i_user_id => FND_GLOBAL.user_id
4538: ,i_login_id => FND_GLOBAL.login_id
4539: ,i_request_id => FND_GLOBAL.conc_request_id
4540: ,i_prog_id => FND_GLOBAL.conc_program_id
4541: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4542: ,o_err_num => l_error_num
4543: ,o_err_code => l_error_code
4544: ,o_err_msg => l_error_msg

Line 4541: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id

4537: ,i_user_id => FND_GLOBAL.user_id
4538: ,i_login_id => FND_GLOBAL.login_id
4539: ,i_request_id => FND_GLOBAL.conc_request_id
4540: ,i_prog_id => FND_GLOBAL.conc_program_id
4541: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4542: ,o_err_num => l_error_num
4543: ,o_err_code => l_error_code
4544: ,o_err_msg => l_error_msg
4545: );