APPS.FLM_RECEIPT_PUB dependencies on RCV_SHIPMENT_HEADERS

Line 573: l_log_module || '.rcv_shipment_headers',

569: l_employee_id := get_employee_id;
570:
571: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
573: l_log_module || '.rcv_shipment_headers',
574: 'Before rcv_shipment_headers_pkg.insert_row');
575: END IF;
576:
577: rcv_shipment_headers_pkg.insert_row

Line 574: 'Before rcv_shipment_headers_pkg.insert_row');

570:
571: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
573: l_log_module || '.rcv_shipment_headers',
574: 'Before rcv_shipment_headers_pkg.insert_row');
575: END IF;
576:
577: rcv_shipment_headers_pkg.insert_row
578: ( X_Rowid => l_rowid,

Line 577: rcv_shipment_headers_pkg.insert_row

573: l_log_module || '.rcv_shipment_headers',
574: 'Before rcv_shipment_headers_pkg.insert_row');
575: END IF;
576:
577: rcv_shipment_headers_pkg.insert_row
578: ( X_Rowid => l_rowid,
579: X_Shipment_Header_Id => l_shipment_header_id,
580: X_Last_Update_Date => SYSDATE,
581: X_Last_Updated_By => FND_GLOBAL.USER_ID,

Line 630: l_log_module || '.rcv_shipment_headers',

626: );
627:
628: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
630: l_log_module || '.rcv_shipment_headers',
631: 'After rcv_shipment_headers_pkg.insert_row: ' ||
632: 'l_shipment_header_id = ' || l_shipment_header_id || ', ' ||
633: 'x_receipt_num = ' || x_receipt_num);
634: END IF;

Line 631: 'After rcv_shipment_headers_pkg.insert_row: ' ||

627:
628: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
630: l_log_module || '.rcv_shipment_headers',
631: 'After rcv_shipment_headers_pkg.insert_row: ' ||
632: 'l_shipment_header_id = ' || l_shipment_header_id || ', ' ||
633: 'x_receipt_num = ' || x_receipt_num);
634: END IF;
635:

Line 987: FROM rcv_shipment_headers

983: program_application_id,
984: program_id,
985: customer_id,
986: customer_site_id
987: FROM rcv_shipment_headers
988: WHERE shipment_header_id = p_shipment_header_id;
989:
990: TYPE ship_lines_tbl_type IS TABLE OF c_shipment_lines%ROWTYPE INDEX BY BINARY_INTEGER;
991:

Line 1067: FROM rcv_shipment_headers rsh

1063:
1064: LOOP
1065: SELECT COUNT(*)
1066: INTO l_receipt_exists
1067: FROM rcv_shipment_headers rsh
1068: WHERE receipt_num = l_temp_receipt_num
1069: AND ship_to_org_id = l_ship_header_rec.ship_to_org_id;
1070:
1071: IF l_receipt_exists = 0 THEN

Line 1092: l_log_module || '.rcv_shipment_headers',

1088: END IF;
1089:
1090: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1091: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1092: l_log_module || '.rcv_shipment_headers',
1093: 'Calling rcv_shipment_headers_pkg.update_row');
1094: END IF;
1095:
1096: rcv_shipment_headers_pkg.update_row

Line 1093: 'Calling rcv_shipment_headers_pkg.update_row');

1089:
1090: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1091: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1092: l_log_module || '.rcv_shipment_headers',
1093: 'Calling rcv_shipment_headers_pkg.update_row');
1094: END IF;
1095:
1096: rcv_shipment_headers_pkg.update_row
1097: ( X_Rowid => l_ship_header_rec.rowid,

Line 1096: rcv_shipment_headers_pkg.update_row

1092: l_log_module || '.rcv_shipment_headers',
1093: 'Calling rcv_shipment_headers_pkg.update_row');
1094: END IF;
1095:
1096: rcv_shipment_headers_pkg.update_row
1097: ( X_Rowid => l_ship_header_rec.rowid,
1098: X_Shipment_Header_Id => l_ship_header_rec.shipment_header_id,
1099: X_Last_Update_Date => SYSDATE,
1100: X_Last_Updated_By => FND_GLOBAL.USER_ID,