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.INL_SHIPMENT_PVT dependencies on INL_SHIP_HEADERS

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 522: UPDATE inl_ship_headers

518: p_module_name => g_module_name,
519: p_procedure_name=> l_api_name,
520: p_debug_info => l_debug_info ) ;
521:
522: UPDATE inl_ship_headers
523: SET ship_status_code = 'COMPLETED',
524: last_updated_by = L_FND_USER_ID,
525: last_update_date = SYSDATE
526: WHERE ship_header_id = p_ship_header_id;

Line 685: FROM inl_ship_headers sh

681: -- Initialize API return status to success
682: x_return_status := L_FND_RET_STS_SUCCESS;
683: SELECT sh.ship_status_code
684: INTO l_ship_status
685: FROM inl_ship_headers sh
686: WHERE sh.ship_header_id = p_ship_header_id;
687: INL_LOGGING_PVT.Log_Variable (
688: p_module_name => g_module_name,
689: p_procedure_name => l_api_name,

Line 702: UPDATE inl_ship_headers

698: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
699: RAISE L_FND_EXC_UNEXPECTED_ERROR;
700: END IF;
701: -- Update Shipment status to VALIDATION REQ
702: UPDATE inl_ship_headers
703: SET ship_status_code = 'VALIDATION REQ'
704: WHERE ship_header_id = p_ship_header_id;
705: END IF;
706: -- Standard check of p_commit.

Line 888: FROM inl_ship_headers

884: p_procedure_name => l_program_name) ;
885: BEGIN
886: SELECT ship_num
887: INTO l_ship_header_num
888: FROM inl_ship_headers
889: WHERE ship_header_id = p_ship_header_id;
890: EXCEPTION
891: WHEN NO_DATA_FOUND THEN
892: RETURN '';

Line 1524: FROM inl_ship_headers sh,

1520: -- Search for other Shipment lines in Validated Shipments
1521: -- with receipts for the same receipt_source_code and src_id
1522: SELECT NVL (SUM (sl.primary_qty), 0)
1523: INTO x_qty_in_others_ops
1524: FROM inl_ship_headers sh,
1525: inl_adj_ship_lines_v sl
1526: WHERE sl.ship_header_id = sh.ship_header_id
1527: AND NVL (sl.parent_ship_line_id, sl.ship_line_id) <> p_ship_line_id
1528: AND

Line 1560: FROM inl_ship_headers sh,

1556:
1557: SELECT DISTINCT sh.ship_num,
1558: sl.ship_line_num
1559: BULK COLLECT INTO l_ship_qty_validation_inf_tbl
1560: FROM inl_ship_headers sh,
1561: inl_adj_ship_lines_v sl
1562: WHERE sl.ship_header_id = sh.ship_header_id
1563: AND NVL (sl.parent_ship_line_id, sl.ship_line_id) <> p_ship_line_id
1564: AND

Line 1585: FROM inl_ship_headers sh,

1581:
1582: /*FOR c_ship_num IN
1583: (
1584: SELECT DISTINCT sh.ship_num
1585: FROM inl_ship_headers sh,
1586: inl_adj_ship_lines_v sl
1587: WHERE sl.ship_header_id = sh.ship_header_id
1588: AND NVL (sl.parent_ship_line_id, sl.ship_line_id) <> p_ship_line_id
1589: AND

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 2661: p_table_name => 'INL_SHIP_HEADERS',

2657: Handle_ShipError (
2658: p_ship_header_id => p_ship_header_id,
2659: p_ship_line_id => p_ship_line_id,
2660: p_charge_line_id => NULL,
2661: p_table_name => 'INL_SHIP_HEADERS',
2662: p_column_name => 'ORG_ID',
2663: p_column_value => 0,
2664: p_error_message => SUBSTR (FND_MSG_PUB.Get (
2665: p_msg_index => FND_MSG_PUB.Count_Msg (),

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 3998: p_table_name => 'INL_SHIP_HEADERS',

3994: Handle_ShipError (
3995: p_ship_header_id => p_ship_header_id,
3996: p_ship_line_id => NULL,
3997: p_charge_line_id => NULL,
3998: p_table_name => 'INL_SHIP_HEADERS',
3999: p_column_name => 'SHIP_DATE',
4000: p_column_value => TO_CHAR (l_ship_date),
4001: p_error_message => SUBSTR (FND_MSG_PUB.Get (
4002: p_msg_index => FND_MSG_PUB.Count_Msg (),

Line 4065: p_table_name => 'INL_SHIP_HEADERS',

4061: Handle_ShipError (
4062: p_ship_header_id => p_ship_header_id,
4063: p_ship_line_id => NULL,
4064: p_charge_line_id => NULL,
4065: p_table_name => 'INL_SHIP_HEADERS',
4066: p_column_name => 'SHIP_DATE',
4067: p_column_value => TO_CHAR (l_ship_date),
4068: p_error_message => SUBSTR (FND_MSG_PUB.Get (
4069: p_msg_index => FND_MSG_PUB.Count_Msg (),

Line 4107: p_table_name => 'INL_SHIP_HEADERS',

4103: Handle_ShipError (
4104: p_ship_header_id => p_ship_header_id,
4105: p_ship_line_id => NULL,
4106: p_charge_line_id => NULL,
4107: p_table_name => 'INL_SHIP_HEADERS',
4108: p_column_name => 'SHIP_TYPE_ID',
4109: p_column_value => l_ship_type_id,
4110: p_error_message => SUBSTR (FND_MSG_PUB.Get (
4111: p_msg_index => FND_MSG_PUB.Count_Msg (),

Line 4139: p_table_name => 'INL_SHIP_HEADERS',

4135: Handle_ShipError (
4136: p_ship_header_id => p_ship_header_id,
4137: p_ship_line_id => NULL,
4138: p_charge_line_id => NULL,
4139: p_table_name => 'INL_SHIP_HEADERS',
4140: p_column_name => 'SHIP_TYPE_ID',
4141: p_column_value => l_ship_type_id,
4142: p_error_message => SUBSTR (FND_MSG_PUB.Get (
4143: p_msg_index => FND_MSG_PUB.Count_Msg (),

Line 4455: FROM inl_ship_headers

4451: p_var_value => TO_CHAR (fnd_msg_pub.count_msg)) ;
4452: IF (NVL (fnd_msg_pub.count_msg, 0) = 0) THEN
4453: SELECT ship_status_code
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 (

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 4463: UPDATE inl_ship_headers

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) ;
4463: UPDATE inl_ship_headers
4464: SET ship_status_code = 'VALIDATED',
4465: last_updated_by = L_FND_USER_ID,
4466: last_update_date = SYSDATE
4467: WHERE ship_header_id = p_ship_header_id;

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 4475: UPDATE inl_ship_headers

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) ;
4475: UPDATE inl_ship_headers
4476: SET ship_status_code = 'ON HOLD',
4477: last_updated_by = L_FND_USER_ID,
4478: last_update_date = SYSDATE
4479: WHERE ship_header_id = p_ship_header_id;

Line 5482: inl_ship_headers sh

5478: l_curr_match_id /* 21 */
5479: FROM inl_corr_matches_v mat,
5480: inl_ship_lines sl ,
5481: inl_ship_lines sl0 ,
5482: inl_ship_headers sh
5483: WHERE mat.match_id = p_match_id
5484: AND mat.to_parent_table_name = 'INL_SHIP_LINES'
5485: AND mat.adj_already_generated_flag = 'N'
5486: AND sl.ship_header_id = sh.ship_header_id

Line 6817: (m.to_parent_table_name = 'INL_SHIP_HEADERS'

6813: OR m.match_amount_id = p_match_amount_id
6814: )
6815:
6816: AND (
6817: (m.to_parent_table_name = 'INL_SHIP_HEADERS'
6818: AND a.to_parent_table_name = 'INL_SHIP_HEADERS'
6819: AND m.ship_header_id = a.ship_header_id)
6820: OR
6821: (m.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'

Line 6818: AND a.to_parent_table_name = 'INL_SHIP_HEADERS'

6814: )
6815:
6816: AND (
6817: (m.to_parent_table_name = 'INL_SHIP_HEADERS'
6818: AND a.to_parent_table_name = 'INL_SHIP_HEADERS'
6819: AND m.ship_header_id = a.ship_header_id)
6820: OR
6821: (m.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
6822: AND m.ship_header_id = a.ship_header_id

Line 6823: AND (a.to_parent_table_name = 'INL_SHIP_HEADERS'

6819: AND m.ship_header_id = a.ship_header_id)
6820: OR
6821: (m.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
6822: AND m.ship_header_id = a.ship_header_id
6823: AND (a.to_parent_table_name = 'INL_SHIP_HEADERS'
6824: OR (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
6825: AND a.to_parent_table_id = m.to_parent_table_id)
6826: )
6827: )

Line 6831: AND (a.to_parent_table_name = 'INL_SHIP_HEADERS'

6827: )
6828: OR
6829: (m.to_parent_table_name = 'INL_SHIP_LINES'
6830: AND m.ship_header_id = a.ship_header_id
6831: AND (a.to_parent_table_name = 'INL_SHIP_HEADERS'
6832: OR (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
6833: AND EXISTS (SELECT 1
6834: FROM inl_ship_lines sl
6835: WHERE sl.ship_line_id = m.to_parent_table_id -- the match ship line

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 7122: (a.to_parent_table_name = 'INL_SHIP_HEADERS'

7118: OR
7119: (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
7120: AND a.to_parent_table_id = sl.ship_line_group_id)
7121: OR
7122: (a.to_parent_table_name = 'INL_SHIP_HEADERS'
7123: AND a.to_parent_table_id = sl.ship_header_id))
7124: AND sh.ship_header_id = sl.ship_header_id
7125: AND slg.ship_line_group_id = sl.ship_line_group_id
7126: AND sl.ship_line_id = pc_ship_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 7330: (a.to_parent_table_name = 'INL_SHIP_HEADERS'

7326: OR
7327: (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
7328: AND a.to_parent_table_id = sl.ship_line_group_id)
7329: OR
7330: (a.to_parent_table_name = 'INL_SHIP_HEADERS'
7331: AND a.to_parent_table_id = sl.ship_header_id))
7332: AND sh.ship_header_id = sl.ship_header_id
7333: AND slg.ship_line_group_id = sl.ship_line_group_id
7334: AND sl.ship_line_id = affected_by_alc_ship_lst(i).to_parent_table_id

Line 7481: IF affected_by_elc_lst(k).to_parent_table_name = 'INL_SHIP_HEADERS' then

7477: p_var_value => affected_by_elc_lst(k).to_parent_table_id
7478: ) ;
7479:
7480: -- Search for an actual for this cost factor
7481: IF affected_by_elc_lst(k).to_parent_table_name = 'INL_SHIP_HEADERS' then
7482: SELECT
7483: SUM(cl.charge_amt)
7484: INTO
7485: l_sum_chLnAmt

Line 9733: inl_ship_headers sh ,

9729: --Bug#14044298 gsb.currency_code func_currency_code --BUG#8468830
9730: FROM
9731: --Bug#14044298 inl_charge_lines cl ,
9732: --Bug#14044298 inl_ship_lines sl ,
9733: inl_ship_headers sh ,
9734: inl_corr_matches_v m
9735: --Bug#14044298 org_organization_definitions ood, --BUG#8468830
9736: --Bug#14044298 gl_sets_of_books gsb --BUG#8468830
9737: WHERE

Line 9763: inl_ship_headers sh,

9759: NULL AS to_parent_table_id ,
9760: sh.organization_id --Bug#14044298
9761: --Bug#14044298 gsb.currency_code AS func_currency_code --BUG#8468830
9762: FROM
9763: inl_ship_headers sh,
9764: inl_match_amounts ma,
9765: inl_corr_matches_v m
9766: --Bug#14044298 org_organization_definitions ood, --BUG#8468830
9767: --Bug#14044298 gl_sets_of_books gsb --BUG#8468830

Line 9900: FROM inl_ship_headers

9896: IF NVL(l_adjustment_num,0) = 0 THEN
9897: l_adj_group_date_ant := r_match(i).adj_group_date; --OPM Integration
9898: SELECT NVL(adjustment_num,0) + 1
9899: INTO l_adjustment_num
9900: FROM inl_ship_headers
9901: WHERE ship_header_id = p_ship_header_id FOR UPDATE;
9902: l_debug_info := 'l_adjustment_num';
9903: INL_LOGGING_PVT.Log_Variable (
9904: p_module_name => g_module_name,

Line 9954: FROM inl_ship_headers sh

9950: p_debug_info => l_debug_info
9951: ) ;
9952: SELECT NVL(MAX(sh.adjustment_num),0)+1
9953: INTO l_adjustment_num
9954: FROM inl_ship_headers sh
9955: WHERE sh.ship_header_id
9956: IN (select m1.ship_header_id
9957: from inl_corr_matches_v m1
9958: where m1.match_amount_id

Line 10037: FROM inl_ship_headers sh

10033: p_var_value => r_match(i).match_amount_id
10034: );
10035: SELECT NVL(MAX(sh.adjustment_num),0)
10036: INTO l_adjustment_num_tmp
10037: FROM inl_ship_headers sh
10038: WHERE sh.ship_header_id
10039: IN (SELECT m1.ship_header_id
10040: FROM inl_corr_matches_v m1
10041: WHERE m1.match_type_code <> 'CORRECTION'

Line 10255: UPDATE inl_ship_headers

10251: IF l_has_match_amt = 'Y' THEN
10252: IF NVL (match_ship_header_id_lst.LAST, 0) > 0 THEN
10253: FOR i IN NVL (match_ship_header_id_lst.FIRST, 0) ..NVL (match_ship_header_id_lst.LAST, 0)
10254: LOOP
10255: UPDATE inl_ship_headers
10256: SET adjustment_num = match_ship_header_id_lst(i).adjustment_num
10257: WHERE ship_header_id = match_ship_header_id_lst(i).ship_header_id;
10258:
10259: INL_LOGGING_PVT.Log_Variable (

Line 10276: UPDATE inl_ship_headers

10272:
10273: END LOOP;
10274: END IF;
10275: ELSE
10276: UPDATE inl_ship_headers
10277: SET adjustment_num = l_adjustment_num
10278: WHERE ship_header_id = p_ship_header_id;
10279: END IF;
10280: END IF;

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 12017: FROM inl_ship_headers

12013: l_pending_update_flag, -- SCM-051
12014: l_organization_id,
12015: l_rcv_enabled_flag,
12016: l_ship_num
12017: FROM inl_ship_headers
12018: WHERE ship_header_id = p_ship_header_id;
12019:
12020: INL_LOGGING_PVT.Log_Variable (
12021: p_module_name => g_module_name,

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 12804: inl_ship_headers sh

12800: SELECT a.ship_header_id ,
12801: sh.ship_status_code ship_status,
12802: sh.pending_matching_flag
12803: FROM inl_associations a,
12804: inl_ship_headers sh
12805: WHERE sh.ship_header_id = a.ship_header_id
12806: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
12807: AND a.from_parent_table_id = p_charge_line_id
12808: AND a.ship_header_id <> p_ship_header_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