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.PO_ACKNOWLEDGE_PO_PVT dependencies on PO_ACCEPTANCES

Line 35: From PO_ACCEPTANCES PA

31: From PO_LINE_LOCATIONS_ALL PLL
32: Where pll.po_release_id = p_po_release_id
33: And not exists (
34: select 1
35: From PO_ACCEPTANCES PA
36: Where PA.po_release_id = p_po_release_id
37: And pa.revision_num = p_revision_num
38: And pa.po_line_location_id = PLL.line_location_id )
39: And nvl(pll.cancel_flag, 'N') = 'N'

Line 53: From PO_ACCEPTANCES PA

49: Where pll.po_header_id = p_po_header_id
50: And pll.po_release_id is null
51: And not exists (
52: select 1
53: From PO_ACCEPTANCES PA
54: Where PA.po_header_id = p_po_header_id
55: And pa.revision_num = p_revision_num
56: And pa.po_line_location_id = PLL.line_location_id )
57: And nvl(pll.cancel_flag, 'N') = 'N'

Line 162: from PO_ACCEPTANCES

158: l_arch_revision_num NUMBER := p_revision_num;
159:
160: CURSOR l_po_ship_ack_exists_csr IS
161: select 'Y'
162: from PO_ACCEPTANCES
163: where po_header_id = p_po_header_id
164: and po_release_id is null
165: and revision_num = p_revision_num
166: and po_line_location_id is not null;

Line 170: from PO_ACCEPTANCES

166: and po_line_location_id is not null;
167:
168: CURSOR l_rel_ship_ack_exists_csr IS
169: select 'Y'
170: from PO_ACCEPTANCES
171: where po_header_id is null
172: and po_release_id = p_po_release_id
173: and revision_num = p_revision_num
174: and po_line_location_id is not null;

Line 178: from PO_ACCEPTANCES

174: and po_line_location_id is not null;
175:
176: CURSOR l_sup_sign_exists_csr IS
177: select 'Y'
178: from PO_ACCEPTANCES
179: where po_header_id = p_po_header_id
180: and revision_num = p_revision_num
181: and po_release_id is null
182: and po_line_location_id is null

Line 189: from PO_ACCEPTANCES

185: and signature_flag = 'Y';
186:
187: CURSOR l_reject_sign_exists_csr IS
188: select 'Y'
189: from PO_ACCEPTANCES
190: where po_header_id = p_po_header_id
191: and revision_num = p_revision_num
192: and po_release_id is null
193: and po_line_location_id is null

Line 405: from PO_ACCEPTANCES

401: BEGIN
402: /* Get header level accepted_flag. */
403: select accepted_flag
404: into l_accepted_flag
405: from PO_ACCEPTANCES
406: where acceptance_id = (
407: select max(acceptance_id)
408: from PO_ACCEPTANCES
409: where po_release_id = p_po_release_id

Line 408: from PO_ACCEPTANCES

404: into l_accepted_flag
405: from PO_ACCEPTANCES
406: where acceptance_id = (
407: select max(acceptance_id)
408: from PO_ACCEPTANCES
409: where po_release_id = p_po_release_id
410: and revision_num = p_revision_num
411: and po_line_location_id is null );
412:

Line 422: from PO_ACCEPTANCES

418: ELSIF (p_po_header_id is not null) THEN
419: BEGIN
420: select accepted_flag
421: into l_accepted_flag
422: from PO_ACCEPTANCES
423: where acceptance_id = (
424: select max(acceptance_id)
425: from PO_ACCEPTANCES
426: where po_header_id = p_po_header_id

Line 425: from PO_ACCEPTANCES

421: into l_accepted_flag
422: from PO_ACCEPTANCES
423: where acceptance_id = (
424: select max(acceptance_id)
425: from PO_ACCEPTANCES
426: where po_header_id = p_po_header_id
427: and po_release_id is null
428: and revision_num = p_revision_num
429: and po_line_location_id is null );

Line 458: * Modifies: PO_ACCEPTANCES

454: /**
455: * Private procedure: Acknowledge_Po
456: * Requires: PO_HEADER_ID, PO_RELEASE_ID, REVISION_NUM, ACCEPTED_FLAG,
457: * COMMENT, BUYER_ID, USER_ID
458: * Modifies: PO_ACCEPTANCES
459: * Effects: Insert header level acknowledgement result into PO_ACCEPTANCES
460: * table, also update ACCEPTANCE_REQUIRED_FLAG at PO header level.
461: */
462:

Line 459: * Effects: Insert header level acknowledgement result into PO_ACCEPTANCES

455: * Private procedure: Acknowledge_Po
456: * Requires: PO_HEADER_ID, PO_RELEASE_ID, REVISION_NUM, ACCEPTED_FLAG,
457: * COMMENT, BUYER_ID, USER_ID
458: * Modifies: PO_ACCEPTANCES
459: * Effects: Insert header level acknowledgement result into PO_ACCEPTANCES
460: * table, also update ACCEPTANCE_REQUIRED_FLAG at PO header level.
461: */
462:
463: PROCEDURE Acknowledge_Po (

Line 476: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;

472: IS
473:
474: -- Bug 2850566
475: l_rowid ROWID;
476: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
477: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
478: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
479: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
480: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;

Line 477: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;

473:
474: -- Bug 2850566
475: l_rowid ROWID;
476: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
477: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
478: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
479: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
480: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;
481: -- End of Bug 2850566

Line 479: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;

475: l_rowid ROWID;
476: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
477: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
478: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
479: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
480: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;
481: -- End of Bug 2850566
482:
483: BEGIN

Line 480: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;

476: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
477: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
478: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
479: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
480: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;
481: -- End of Bug 2850566
482:
483: BEGIN
484:

Line 486: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table

482:
483: BEGIN
484:
485: -- Bug 2850566 RBAIRRAJ
486: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table
487: -- instead of writing an Insert statement.
488:
489: IF p_po_release_id IS NULL THEN
490: l_acc_po_header_id := p_po_header_id;

Line 497: PO_ACCEPTANCES_INS_PVT.insert_row(

493: END IF;
494:
495: l_user_id := p_user_id;
496:
497: PO_ACCEPTANCES_INS_PVT.insert_row(
498: x_rowid => l_rowid,
499: x_acceptance_id => l_acceptance_id,
500: x_Last_Update_Date => l_Last_Update_Date,
501: x_Last_Updated_By => l_user_id,

Line 913: from PO_ACCEPTANCES

909: /* Check if shipment has been acknowledged. */
910: BEGIN
911: select accepted_flag
912: into l_ship_accepted_flag
913: from PO_ACCEPTANCES
914: where po_line_location_id = P_line_location_id
915: and revision_num = l_revision_num
916: and acceptance_id = (select MAX(acceptance_id)
917: from PO_ACCEPTANCES PA2

Line 917: from PO_ACCEPTANCES PA2

913: from PO_ACCEPTANCES
914: where po_line_location_id = P_line_location_id
915: and revision_num = l_revision_num
916: and acceptance_id = (select MAX(acceptance_id)
917: from PO_ACCEPTANCES PA2
918: where PA2.po_line_location_id = P_line_location_id
919: and PA2.revision_num = l_revision_num );
920:
921: EXCEPTION

Line 947: from PO_ACCEPTANCES

943: ELSE
944: BEGIN
945: select accepted_flag
946: into l_header_accepted_flag
947: from PO_ACCEPTANCES
948: where acceptance_id = (
949: select max(acceptance_id)
950: from PO_ACCEPTANCES
951: where po_release_id = p_po_release_id

Line 950: from PO_ACCEPTANCES

946: into l_header_accepted_flag
947: from PO_ACCEPTANCES
948: where acceptance_id = (
949: select max(acceptance_id)
950: from PO_ACCEPTANCES
951: where po_release_id = p_po_release_id
952: and revision_num = l_revision_num
953: and po_line_location_id is null );
954:

Line 974: from PO_ACCEPTANCES

970: ELSE
971: BEGIN
972: select accepted_flag
973: into l_header_accepted_flag
974: from PO_ACCEPTANCES
975: where acceptance_id = (
976: select max(acceptance_id)
977: from PO_ACCEPTANCES
978: where po_header_id = p_po_header_id

Line 977: from PO_ACCEPTANCES

973: into l_header_accepted_flag
974: from PO_ACCEPTANCES
975: where acceptance_id = (
976: select max(acceptance_id)
977: from PO_ACCEPTANCES
978: where po_header_id = p_po_header_id
979: and po_release_id is null
980: and revision_num = l_revision_num
981: and po_line_location_id is null );

Line 1017: * Modifies: PO_ACCEPTANCES

1013: /**
1014: * Public procedure: Acknowledge_Shipment
1015: * Requires: LINE_LOCATION_ID, PO_HEADER_ID, PO_RELEASE_ID, REVISION_NUM,
1016: * ACCEPTED_FLAG, COMMENT, BUYER_ID, USER_ID
1017: * Modifies: PO_ACCEPTANCES
1018: * Effects: Insert shipment level acknowledgement result into PO_ACCEPTANCES
1019: * table. Also checks if all shipments have been acknowledged after
1020: * insertion, if yes then post the header level acknowledge result.
1021: */

Line 1018: * Effects: Insert shipment level acknowledgement result into PO_ACCEPTANCES

1014: * Public procedure: Acknowledge_Shipment
1015: * Requires: LINE_LOCATION_ID, PO_HEADER_ID, PO_RELEASE_ID, REVISION_NUM,
1016: * ACCEPTED_FLAG, COMMENT, BUYER_ID, USER_ID
1017: * Modifies: PO_ACCEPTANCES
1018: * Effects: Insert shipment level acknowledgement result into PO_ACCEPTANCES
1019: * table. Also checks if all shipments have been acknowledged after
1020: * insertion, if yes then post the header level acknowledge result.
1021: */
1022:

Line 1039: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;

1035: IS
1036:
1037: -- Bug 2850566
1038: l_rowid ROWID;
1039: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
1040: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
1041: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1042: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
1043: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;

Line 1040: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;

1036:
1037: -- Bug 2850566
1038: l_rowid ROWID;
1039: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
1040: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
1041: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1042: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
1043: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;
1044: -- End of Bug 2850566

Line 1042: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;

1038: l_rowid ROWID;
1039: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
1040: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
1041: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1042: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
1043: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;
1044: -- End of Bug 2850566
1045:
1046:

Line 1043: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;

1039: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
1040: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
1041: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1042: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
1043: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;
1044: -- End of Bug 2850566
1045:
1046:
1047: l_api_name CONSTANT VARCHAR2(30) := 'ACKNOWLEDGE_SHIPMENT';

Line 1072: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table

1068: NVL(TO_CHAR(p_line_location_id),'null'));
1069: END IF;
1070:
1071: -- Bug 2850566 RBAIRRAJ
1072: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table
1073: -- instead of writing an Insert statement.
1074:
1075: IF(p_accepted_flag = 'Y' AND g_default_promise_date = 'Y') THEN
1076: -- RDP ( defaults the promise date with need by date)

Line 1089: PO_ACCEPTANCES_INS_PVT.insert_row(

1085: END IF;
1086:
1087: l_user_id := p_user_id;
1088:
1089: PO_ACCEPTANCES_INS_PVT.insert_row(
1090: x_rowid => l_rowid,
1091: x_acceptance_id => l_acceptance_id,
1092: x_Last_Update_Date => l_Last_Update_Date,
1093: x_Last_Updated_By => l_user_id,

Line 1138: * Modifies: PO_ACCEPTANCES

1134:
1135: /**
1136: * Public procedure: Carry_Over_Acknowledgement
1137: * Requires: PO_HEADER_ID, PO_RELEASE_ID, REVISION_NUM,
1138: * Modifies: PO_ACCEPTANCES
1139: * Effects: Carry over the shipment_level acknowledgement results from the
1140: * previous revision, it is called before launching PO approval
1141: * workflow after supplier's change has been accepted by buyer.
1142: * Returns:

Line 1164: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;

1160: l_api_version CONSTANT NUMBER := 1.0;
1161:
1162: -- Bug 2850566 RBAIRRAJ
1163: l_rowid ROWID;
1164: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
1165: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
1166: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
1167: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
1168: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;

Line 1165: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;

1161:
1162: -- Bug 2850566 RBAIRRAJ
1163: l_rowid ROWID;
1164: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
1165: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
1166: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
1167: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
1168: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;
1169:

Line 1166: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;

1162: -- Bug 2850566 RBAIRRAJ
1163: l_rowid ROWID;
1164: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
1165: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
1166: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
1167: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
1168: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;
1169:
1170: CURSOR c1_csr IS

Line 1167: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;

1163: l_rowid ROWID;
1164: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
1165: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
1166: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
1167: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
1168: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;
1169:
1170: CURSOR c1_csr IS
1171: Select

Line 1168: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;

1164: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
1165: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
1166: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
1167: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
1168: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;
1169:
1170: CURSOR c1_csr IS
1171: Select
1172: PA.created_by,

Line 1178: from PO_ACCEPTANCES PA

1174: PA.action,
1175: PA.action_date,
1176: PA.accepted_flag,
1177: PA.Last_Updated_By
1178: from PO_ACCEPTANCES PA
1179: Where PA.po_release_id = p_po_release_id
1180: And PA.revision_num = p_revision_num - 1
1181: And PA.po_line_location_id is not null
1182: AND NOT EXISTS ( select 1

Line 1183: From PO_ACCEPTANCES PA2

1179: Where PA.po_release_id = p_po_release_id
1180: And PA.revision_num = p_revision_num - 1
1181: And PA.po_line_location_id is not null
1182: AND NOT EXISTS ( select 1
1183: From PO_ACCEPTANCES PA2
1184: Where PA2.po_release_id = p_po_release_id
1185: And PA2.revision_num = p_revision_num
1186: And PA2.po_line_location_id = PA.po_line_location_id);
1187:

Line 1201: From PO_ACCEPTANCES PA2

1197: and PCR.initiator = 'SUPPLIER'
1198: And PCR.action_type = 'MODIFICATION'
1199: and PCR.REQUEST_LEVEL = 'SHIPMENT'
1200: AND NOT EXISTS ( select 1
1201: From PO_ACCEPTANCES PA2
1202: Where PA2.po_release_id = p_po_release_id
1203: And PA2.revision_num = p_revision_num
1204: And PA2.po_line_location_id = PCR.document_line_location_id);
1205:

Line 1215: from PO_ACCEPTANCES PA

1211: PA.action,
1212: PA.action_date,
1213: PA.accepted_flag,
1214: PA.Last_Updated_By
1215: from PO_ACCEPTANCES PA
1216: Where PA.po_header_id = p_po_header_id
1217: and PA.po_release_id is null
1218: And PA.revision_num = p_revision_num - 1
1219: And PA.po_line_location_id is not null

Line 1221: From PO_ACCEPTANCES PA2

1217: and PA.po_release_id is null
1218: And PA.revision_num = p_revision_num - 1
1219: And PA.po_line_location_id is not null
1220: AND NOT EXISTS ( select 1
1221: From PO_ACCEPTANCES PA2
1222: Where PA2.po_release_id = p_po_release_id
1223: And PA2.revision_num = p_revision_num
1224: And PA2.po_line_location_id = PA.po_line_location_id);
1225:

Line 1240: From PO_ACCEPTANCES PA2

1236: and PCR.initiator = 'SUPPLIER'
1237: And PCR.action_type = 'MODIFICATION'
1238: and PCR.REQUEST_LEVEL = 'SHIPMENT'
1239: AND NOT EXISTS ( select 1
1240: From PO_ACCEPTANCES PA2
1241: Where PA2.po_header_id = p_po_header_id
1242: And PA2.po_release_id is null
1243: And PA2.revision_num = p_revision_num
1244: And PA2.po_line_location_id = PCR.document_line_location_id);

Line 1281: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table

1277: where po_release_id = p_po_release_id;
1278:
1279:
1280: -- Bug 2850566 RBAIRRAJ
1281: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table
1282: -- instead of writing an Insert statement.
1283: for c1_rec in c1_csr
1284: loop
1285:

Line 1289: PO_ACCEPTANCES_INS_PVT.insert_row(

1285:
1286: l_user_id := c1_rec.Last_Updated_By;
1287: l_acceptance_id := NULL;
1288:
1289: PO_ACCEPTANCES_INS_PVT.insert_row(
1290: x_rowid => l_rowid,
1291: x_acceptance_id => l_acceptance_id,
1292: x_Last_Update_Date => l_Last_Update_Date,
1293: x_Last_Updated_By => l_user_id,

Line 1312: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table

1308: /* If a shipment-level change has been approved, we'll treat this
1309: shipment as being accepted by the supplier. */
1310:
1311: -- Bug 2850566 RBAIRRAJ
1312: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table
1313: -- instead of writing an Insert statement.
1314: for c2_rec in c2_csr
1315: loop
1316: l_acceptance_id := NULL;

Line 1319: PO_ACCEPTANCES_INS_PVT.insert_row(

1315: loop
1316: l_acceptance_id := NULL;
1317: l_Last_Updated_By := NULL;
1318:
1319: PO_ACCEPTANCES_INS_PVT.insert_row(
1320: x_rowid => l_rowid,
1321: x_acceptance_id => l_acceptance_id,
1322: x_Last_Update_Date => l_Last_Update_Date,
1323: x_Last_Updated_By => l_Last_Updated_By,

Line 1346: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table

1342: where po_header_id = p_po_header_id;
1343:
1344:
1345: -- Bug 2850566 RBAIRRAJ
1346: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table
1347: -- instead of writing an Insert statement.
1348:
1349: for c3_rec in c3_csr
1350: loop

Line 1354: PO_ACCEPTANCES_INS_PVT.insert_row(

1350: loop
1351: l_user_id := c3_rec.Last_Updated_By;
1352: l_acceptance_id := NULL;
1353:
1354: PO_ACCEPTANCES_INS_PVT.insert_row(
1355: x_rowid => l_rowid,
1356: x_acceptance_id => l_acceptance_id,
1357: x_Last_Update_Date => l_Last_Update_Date,
1358: x_Last_Updated_By => l_user_id,

Line 1377: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table

1373: shipment as being accepted by the supplier. */
1374:
1375:
1376: -- Bug 2850566 RBAIRRAJ
1377: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table
1378: -- instead of writing an Insert statement.
1379:
1380: for c4_rec in c4_csr
1381: loop

Line 1385: PO_ACCEPTANCES_INS_PVT.insert_row(

1381: loop
1382: l_acceptance_id := NULL;
1383: l_Last_Updated_By := NULL;
1384:
1385: PO_ACCEPTANCES_INS_PVT.insert_row(
1386: x_rowid => l_rowid,
1387: x_acceptance_id => l_acceptance_id,
1388: x_Last_Update_Date => l_Last_Update_Date,
1389: x_Last_Updated_By => l_Last_Updated_By,

Line 1431: From PO_ACCEPTANCES

1427: into l_header_accepted_flag
1428: From sys.dual
1429: Where exists (
1430: select 1
1431: From PO_ACCEPTANCES
1432: Where po_release_id = p_po_release_id
1433: and revision_num = p_revision_num
1434: and po_line_location_id is not null
1435: and accepted_flag <> 'Y' );

Line 1443: From PO_ACCEPTANCES

1439: into l_header_accepted_flag
1440: From sys.dual
1441: Where exists (
1442: select 'Y'
1443: From PO_ACCEPTANCES
1444: Where po_header_id = p_po_header_id
1445: and po_release_id is null
1446: and revision_num = p_revision_num
1447: and po_line_location_id is not null

Line 1520: From PO_ACCEPTANCES PA

1516: From PO_LINE_LOCATIONS_ALL PLL
1517: Where pll.po_release_id = p_po_release_id
1518: And not exists (
1519: select 1
1520: From PO_ACCEPTANCES PA
1521: Where PA.po_release_id = p_po_release_id
1522: And pa.revision_num = p_revision_num
1523: And pa.po_line_location_id = PLL.line_location_id )
1524: And not exists (

Line 1554: From PO_ACCEPTANCES PA

1550: Where pll.po_header_id = p_po_header_id
1551: And pll.po_release_id is null
1552: And not exists (
1553: select 1
1554: From PO_ACCEPTANCES PA
1555: Where PA.po_header_id = p_po_header_id
1556: And pa.revision_num = p_revision_num
1557: And pa.po_line_location_id = PLL.line_location_id )
1558: And not exists (

Line 1644: * Modifies: PO_ACCEPTANCES

1640:
1641: /**
1642: * Public procedure: Set_Header_Acknowledgement
1643: * Requires: PO_HEADER_ID, PO_RELEASE_ID
1644: * Modifies: PO_ACCEPTANCES
1645: * Effects: For ack required PO, check if all shipments has been acknowledged
1646: * and if there is no supplier change pending, if both conditions
1647: * satisfied, post the header level acknowledgement record.
1648: * This API should be called after supplier submits the change requests and

Line 1674: FROM po_acceptances

1670: l_buyer_id NUMBER;
1671:
1672: CURSOR l_rel_ship_accp_csr(rev_num NUMBER) IS
1673: SELECT accepted_flag
1674: FROM po_acceptances
1675: WHERE po_release_id = p_po_release_id
1676: AND revision_num = rev_num
1677: AND po_line_location_id is not null;
1678:

Line 1681: FROM po_acceptances

1677: AND po_line_location_id is not null;
1678:
1679: CURSOR l_po_ship_accp_csr(rev_num NUMBER) IS
1680: SELECT accepted_flag
1681: FROM po_acceptances
1682: WHERE po_header_id = p_po_header_id
1683: AND revision_num = rev_num
1684: AND po_line_location_id is not null;
1685:

Line 1796: FROM PO_ACCEPTANCES

1792: INTO l_header_accepted_flag
1793: FROM sys.dual
1794: WHERE exists (
1795: SELECT 1
1796: FROM PO_ACCEPTANCES
1797: WHERE po_release_id = p_po_release_id
1798: AND revision_num = l_revision_num
1799: AND po_line_location_id is not null
1800: AND accepted_flag <> l_ship_accepted_flag );

Line 1808: FROM PO_ACCEPTANCES

1804: INTO l_header_accepted_flag
1805: FROM sys.dual
1806: WHERE exists (
1807: SELECT 'Y'
1808: FROM PO_ACCEPTANCES
1809: WHERE po_header_id = p_po_header_id
1810: AND po_release_id is null
1811: AND revision_num = l_revision_num
1812: AND po_line_location_id is not null