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.

[Home] [Help]

APPS.INL_SHIPMENT_PVT dependencies on INL_SHIP_HEADERS_ALL

Line 516: l_debug_info := 'Update the current INL_SHIP_HEADERS_ALL.ship_status_code to COMPLETED';

512: RAISE L_FND_EXC_UNEXPECTED_ERROR;
513: END IF;
514: END IF;
515:
516: l_debug_info := 'Update the current INL_SHIP_HEADERS_ALL.ship_status_code to COMPLETED';
517: INL_LOGGING_PVT.Log_Statement (
518: p_module_name => g_module_name,
519: p_procedure_name=> l_api_name,
520: p_debug_info => l_debug_info ) ;

Line 2341: FROM inl_ship_headers_all ish

2337: BEGIN
2338: -- during insert from UI at this point the record has not been posted yet
2339: SELECT ish.ship_status_code
2340: INTO l_ship_status_code
2341: FROM inl_ship_headers_all ish
2342: WHERE ish.ship_header_id = p_ship_header_id;
2343: EXCEPTION
2344: WHEN NO_DATA_FOUND THEN
2345: l_ship_status_code := 'INCOMPLETE';

Line 2628: FROM inl_ship_headers_all ish,

2624: SELECT ish.org_id LCM_ORG_ID,
2625: ph.org_id PO_ORG_ID
2626: INTO l_lcm_org_id,
2627: l_po_org_id
2628: FROM inl_ship_headers_all ish,
2629: inl_ship_lines_all isl,
2630: po_headers_all ph,
2631: po_line_locations_all pll
2632: WHERE isl.ship_header_id = ish.ship_header_id

Line 3967: FROM inl_ship_headers_all sh,

3963: l_location_id,
3964: l_ship_date,
3965: l_pending_matching_flag,
3966: l_taxation_country
3967: FROM inl_ship_headers_all sh,
3968: inl_ship_types_vl shipt
3969: WHERE sh.ship_type_id = shipt.ship_type_id
3970: AND sh.ship_header_id = p_ship_header_id;
3971: IF l_ship_status = 'COMPLETED' AND l_pending_matching_flag = 'Y' THEN

Line 4458: l_debug_info := 'Update INL_SHIP_HEADERS_ALL.ship_status_code to VALIDATED';

4454: INTO l_ship_status
4455: FROM inl_ship_headers
4456: WHERE ship_header_id = p_ship_header_id;
4457: IF l_ship_status <> 'COMPLETED' THEN
4458: l_debug_info := 'Update INL_SHIP_HEADERS_ALL.ship_status_code to VALIDATED';
4459: INL_LOGGING_PVT.Log_Statement (
4460: p_module_name => g_module_name,
4461: p_procedure_name => l_api_name,
4462: p_debug_info => l_debug_info) ;

Line 4470: l_debug_info := 'Update INL_SHIP_HEADERS_ALL.ship_status_code to ON HOLD';

4466: last_update_date = SYSDATE
4467: WHERE ship_header_id = p_ship_header_id;
4468: END IF;
4469: ELSE
4470: l_debug_info := 'Update INL_SHIP_HEADERS_ALL.ship_status_code to ON HOLD';
4471: INL_LOGGING_PVT.Log_Statement (
4472: p_module_name => g_module_name,
4473: p_procedure_name => l_api_name,
4474: p_debug_info => l_debug_info) ;

Line 7109: inl_ship_headers_all sh

7105: inl_charge_lines cl,
7106: inl_associations a,
7107: inl_ship_lines_all sl,
7108: inl_ship_line_groups slg,
7109: inl_ship_headers_all sh
7110: WHERE
7111: cl.adjustment_num = 0
7112: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
7113: AND a.from_parent_table_id = cl.charge_line_id

Line 7320: inl_ship_headers_all sh

7316: inl_adj_charge_lines_v cl,
7317: inl_adj_associations_v a, --BUG#9804065
7318: inl_ship_lines_all sl,
7319: inl_ship_line_groups slg,
7320: inl_ship_headers_all sh
7321: WHERE
7322: a.ship_header_id = sl.ship_header_id
7323: AND cl.charge_line_type_id = p_charge_line_type_id --same cost factor
7324: AND ((a.to_parent_table_name = 'INL_SHIP_LINES'

Line 11131: FROM inl_ship_headers_all sh,

11127: CURSOR c_elc_adj_shiplines IS
11128: SELECT sl.ship_line_id, sl.new_txn_unit_price,
11129: sl.primary_qty, sl.secondary_qty, sl.txn_qty,
11130: sl.primary_uom_code, sl.secondary_uom_code
11131: FROM inl_ship_headers_all sh,
11132: inl_adj_ship_lines_v sl
11133: WHERE(sl.new_txn_unit_price IS NOT NULL
11134: OR sl.new_currency_conversion_type IS NOT NULL
11135: OR sl.new_currency_conversion_date IS NOT NULL

Line 11147: FROM inl_ship_headers_all sh,

11143:
11144: -- Get ELC Adjustments for Charge Lines
11145: CURSOR c_elc_adj_chlines IS
11146: SELECT DISTINCT charge_line_id
11147: FROM inl_ship_headers_all sh,
11148: inl_adj_charge_lines_v cl,
11149: inl_adj_associations_v a
11150: WHERE sh.ship_header_id = a.ship_header_id
11151: AND a.from_parent_table_id = cl.charge_line_id

Line 11200: FROM inl_ship_headers_all sh

11196: p_debug_info => l_debug_info);
11197:
11198: SELECT (ABS(adjustment_num) +1) *-1
11199: INTO l_adjustment_num
11200: FROM inl_ship_headers_all sh
11201: WHERE sh.ship_header_id = p_ship_header_id FOR UPDATE NOWAIT;
11202:
11203: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
11204: p_procedure_name => l_program_name,

Line 11842: UPDATE inl_ship_headers_all sh

11838: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,
11839: p_procedure_name => l_program_name,
11840: p_debug_info => l_debug_info);
11841:
11842: UPDATE inl_ship_headers_all sh
11843: SET sh.adjustment_num = ABS(l_adjustment_num),
11844: sh.pending_update_flag = 'N',
11845: sh.last_update_login = l_fnd_login_id,
11846: sh.last_update_date = SYSDATE,

Line 12381: FROM inl_ship_headers_all --Bug#10381495

12377:
12378: -- Cursor to get all Pending Shipments
12379: CURSOR c_pending_shipments IS
12380: SELECT ship_header_id, org_id --Bug#10381495
12381: FROM inl_ship_headers_all --Bug#10381495
12382: WHERE ship_status_code = 'COMPLETED'
12383: AND pending_matching_flag = 'Y'
12384: AND (p_organization_id IS NULL
12385: OR organization_id = p_organization_id);

Line 12432: FROM inl_ship_headers_all

12428:
12429: --Bug#10381495
12430: SELECT org_id
12431: INTO l_org_id
12432: FROM inl_ship_headers_all
12433: WHERE ship_header_id = p_ship_header_id;
12434:
12435: IF (l_org_id <> l_current_org_id) THEN
12436: INL_LOGGING_PVT.Log_Statement(

Line 12715: UPDATE inl_ship_headers_all sh --Bug#10381495

12711: BEGIN
12712: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_program_name) ;
12713: -- Initialize API return status to success
12714: x_return_status := L_FND_RET_STS_SUCCESS;
12715: UPDATE inl_ship_headers_all sh --Bug#10381495
12716: SET sH.pending_matching_flag = p_pending_matching_flag ,
12717: -- created_by = L_FND_USER_ID ,
12718: -- creation_date = SYSDATE ,
12719: sH.last_updated_by = L_FND_USER_ID ,

Line 13351: FROM inl_ship_headers_all ish,

13347: /* --SCM-051
13348: -- Get the functional currency code
13349: SELECT gsb.currency_code
13350: INTO l_func_currency_code
13351: FROM inl_ship_headers_all ish,
13352: gl_sets_of_books gsb,
13353: org_organization_definitions ood
13354: WHERE ish.organization_id = ood.organization_id
13355: AND gsb.set_of_books_id = ood.set_of_books_id

Line 13464: FROM inl_ship_headers_all

13460: p_var_value => p_ship_header_id);
13461:
13462: SELECT NVL(MAX(last_update_date), min_date)
13463: INTO l_header_last_update_date
13464: FROM inl_ship_headers_all
13465: WHERE ship_header_id = p_ship_header_id;
13466:
13467: SELECT NVL(MAX(last_update_date), min_date)
13468: INTO l_group_last_update_date

Line 14087: UPDATE inl_ship_headers_all a

14083: l_debug_info := 'Set to N the ELC flag on Shipment Headers';
14084: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
14085: p_procedure_name => l_program_name,
14086: p_debug_info => l_debug_info);
14087: UPDATE inl_ship_headers_all a
14088: SET a.pending_update_flag = 'N',
14089: a.last_update_login = l_fnd_login_id,
14090: a.last_update_date = SYSDATE,
14091: a.last_updated_by = l_fnd_user_id