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_PRICE_DIFFERENTIALS_PVT dependencies on PO_PRICE_DIFF_INTERFACE

Line 294: -- Copies from PO_PRICE_DIFF_INTERFACE -> PO_PRICE_DIFFERENTIALS

290: -- PO_PRICE_DIFFERENTIALS
291: --Locks:
292: -- None.
293: --Function:
294: -- Copies from PO_PRICE_DIFF_INTERFACE -> PO_PRICE_DIFFERENTIALS
295: --Parameters:
296: --IN:
297: --p_entity_id
298: -- Entity ID to which the Price Differentials belong

Line 344: FROM po_price_diff_interface PDI

340: , nvl(PDI.last_updated_by, FND_GLOBAL.user_id)
341: , nvl(PDI.last_update_login, FND_GLOBAL.login_id)
342: , nvl(PDI.creation_date, sysdate)
343: , nvl(PDI.created_by, FND_GLOBAL.user_id)
344: FROM po_price_diff_interface PDI
345: WHERE PDI.interface_line_id = p_interface_line_id
346: AND nvl(process_status,'ACCEPTED') = 'ACCEPTED';
347:
348: EXCEPTION

Line 817: -- PO_PRICE_DIFF_INTERFACE

813: --Pre-reqs:
814: -- The Parent Lines of the Price Differentials must already be
815: -- inserted into their respective Interface tables.
816: --Modifies:
817: -- PO_PRICE_DIFF_INTERFACE
818: --Locks:
819: -- None.
820: --Function:
821: -- Copies from PO_PRICE_DIFFERENTIALS -> PO_PRICE_DIFF_INTERFACE

Line 821: -- Copies from PO_PRICE_DIFFERENTIALS -> PO_PRICE_DIFF_INTERFACE

817: -- PO_PRICE_DIFF_INTERFACE
818: --Locks:
819: -- None.
820: --Function:
821: -- Copies from PO_PRICE_DIFFERENTIALS -> PO_PRICE_DIFF_INTERFACE
822: -- Fills up the Price Differentials Interface table based on the following
823: -- order of precedence:
824: -- 1) The Req Line's Price Differentials if the Req Line has its
825: -- Resource Status as 'COMPLETE'

Line 893: INSERT INTO po_price_diff_interface

889: END IF;
890:
891: -- Insert into Interface Table
892:
893: INSERT INTO po_price_diff_interface
894: (
895: price_diff_interface_id
896: , price_differential_num
897: , interface_header_id

Line 912: SELECT PO_PRICE_DIFF_INTERFACE_S.nextval

908: , last_update_login
909: , creation_date
910: , created_by
911: )
912: SELECT PO_PRICE_DIFF_INTERFACE_S.nextval
913: , PD.price_differential_num
914: , p_interface_header_id
915: , p_interface_line_id
916: , p_entity_type

Line 953: -- PO_PRICE_DIFF_INTERFACE

949: --Name: validate_price_differentials
950: --Pre-reqs:
951: -- None
952: --Modifies:
953: -- PO_PRICE_DIFF_INTERFACE
954: --Locks:
955: -- None
956: --Function:
957: -- 1) Performs validations on the price differentials data in the

Line 958: -- PO_PRICE_DIFF_INTERFACE table.

954: --Locks:
955: -- None
956: --Function:
957: -- 1) Performs validations on the price differentials data in the
958: -- PO_PRICE_DIFF_INTERFACE table.
959: -- a) Price Differential has a valid interface header ID.
960: -- b) Price Differential has a valid Price Type that is seeded
961: -- in the PO_PRICE_TYPE lookup table.
962: -- c) No multiple price differentials records of the same type

Line 1006: FROM PO_PRICE_DIFF_INTERFACE

1002: IS
1003:
1004: CURSOR l_price_diff_csr IS
1005: SELECT *
1006: FROM PO_PRICE_DIFF_INTERFACE
1007: WHERE interface_line_id = p_interface_line_id;
1008:
1009: l_price_diff_record l_price_diff_csr%ROWTYPE;
1010: l_price_diff_num PO_PRICE_DIFFERENTIALS.price_differential_num%TYPE;

Line 1042: X_table_name => 'PO_PRICE_DIFF_INTERFACE',

1038: X_batch_id => NULL,
1039: X_interface_header_id => p_interface_header_id,
1040: X_interface_line_id => p_interface_line_id,
1041: X_error_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
1042: X_table_name => 'PO_PRICE_DIFF_INTERFACE',
1043: X_column_name => 'INTERFACE_HEADER_ID',
1044: X_TokenName1 => 'COLUMN_NAME',
1045: X_TokenName2 => NULL,
1046: X_TokenName3 => NULL,

Line 1069: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',

1065: X_Batch_id => NULL,
1066: X_Interface_Header_Id => p_interface_header_id,
1067: X_Interface_Line_id => p_interface_line_id,
1068: X_Error_message_name => 'PO_PDOI_SVC_INVALID_INT_HDR_ID',
1069: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',
1070: X_Column_name => 'INTERFACE_HEADER_ID',
1071: X_TokenName1 => NULL,
1072: X_TokenName2 => NULL,
1073: X_TokenName3 => NULL,

Line 1099: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',

1095: X_Batch_id => NULL,
1096: X_Interface_Header_Id => p_interface_header_id,
1097: X_Interface_Line_id => p_interface_line_id,
1098: X_Error_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
1099: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',
1100: X_Column_name => 'PRICE_TYPE',
1101: X_TokenName1 => 'COLUMN_NAME',
1102: X_TokenName2 => NULL,
1103: X_TokenName3 => NULL,

Line 1139: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',

1135: X_Batch_id => NULL,
1136: X_Interface_Header_Id => p_interface_header_id,
1137: X_Interface_Line_id => p_interface_line_id,
1138: X_Error_message_name => 'PO_PDOI_SVC_INVALID_PRICE_TYPE',
1139: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',
1140: X_Column_name => 'PRICE_TYPE',
1141: X_TokenName1 => NULL,
1142: X_TokenName2 => NULL,
1143: X_TokenName3 => NULL,

Line 1181: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',

1177: X_Batch_id => NULL,
1178: X_Interface_Header_Id => p_interface_header_id,
1179: X_Interface_Line_id => p_interface_line_id,
1180: X_Error_message_name => 'PO_PDOI_SVC_NO_MULTI_DIFF',
1181: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',
1182: X_Column_name => 'PRICE_TYPE',
1183: X_TokenName1 => NULL,
1184: X_TokenName2 => NULL,
1185: X_TokenName3 => NULL,

Line 1204: FROM PO_PRICE_DIFF_INTERFACE

1200: l_progress := '050';
1201:
1202: SELECT COUNT(*)
1203: INTO l_count
1204: FROM PO_PRICE_DIFF_INTERFACE
1205: WHERE interface_line_id = p_interface_line_id
1206: AND price_type = l_price_diff_record.price_type;
1207:
1208: IF (l_count > 1) THEN

Line 1218: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',

1214: X_Batch_id => NULL,
1215: X_Interface_Header_Id => p_interface_header_id,
1216: X_Interface_Line_id => p_interface_line_id,
1217: X_Error_message_name => 'PO_PDOI_SVC_NO_MULTI_DIFF',
1218: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',
1219: X_Column_name => 'NULL',
1220: X_TokenName1 => NULL,
1221: X_TokenName2 => NULL,
1222: X_TokenName3 => NULL,

Line 1252: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',

1248: X_Batch_id => NULL,
1249: X_Interface_Header_Id => p_interface_header_id,
1250: X_Interface_Line_id => p_interface_line_id,
1251: X_Error_message_name => 'PO_PDOI_SVC_INVALID_ENT_TYPE',
1252: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',
1253: X_Column_name => 'ENTITY_TYPE',
1254: X_TokenName1 => NULL,
1255: X_TokenName2 => NULL,
1256: X_TokenName3 => NULL,

Line 1287: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',

1283: X_Batch_id => NULL,
1284: X_Interface_Header_Id => p_interface_header_id,
1285: X_Interface_Line_id => p_interface_line_id,
1286: X_Error_message_name => 'PO_PDOI_SVC_MUST_MULTIPLIER',
1287: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',
1288: X_Column_name => 'MULTIPLIER',
1289: X_TokenName1 => NULL,
1290: X_TokenName2 => NULL,
1291: X_TokenName3 => NULL,

Line 1316: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',

1312: X_Batch_id => NULL,
1313: X_Interface_Header_Id => p_interface_header_id,
1314: X_Interface_Line_id => p_interface_line_id,
1315: X_Error_message_name => 'PO_PDOI_SVC_NO_MIN_MULT',
1316: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',
1317: X_Column_name => 'MIN_MULTIPLIER',
1318: X_TokenName1 => NULL,
1319: X_TokenName2 => NULL,
1320: X_TokenName3 => NULL,

Line 1345: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',

1341: X_Batch_id => NULL,
1342: X_Interface_Header_Id => p_interface_header_id,
1343: X_Interface_Line_id => p_interface_line_id,
1344: X_Error_message_name => 'PO_PDOI_SVC_NO_MAX_MULT',
1345: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',
1346: X_Column_name => 'MAX_MULTIPLIER',
1347: X_TokenName1 => NULL,
1348: X_TokenName2 => NULL,
1349: X_TokenName3 => NULL,

Line 1383: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',

1379: X_Batch_id => NULL,
1380: X_Interface_Header_Id => p_interface_header_id,
1381: X_Interface_Line_id => p_interface_line_id,
1382: X_Error_message_name => 'PO_PDOI_SVC_MUST_MIN_MULT',
1383: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',
1384: X_Column_name => 'MIN_MULTIPLIER',
1385: X_TokenName1 => NULL,
1386: X_TokenName2 => NULL,
1387: X_TokenName3 => NULL,

Line 1415: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',

1411: X_Batch_id => NULL,
1412: X_Interface_Header_Id => p_interface_header_id,
1413: X_Interface_Line_id => p_interface_line_id,
1414: X_Error_message_name => 'PO_PDOI_SVC_MAX_MULT_GE_MIN',
1415: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',
1416: X_Column_name => 'MAX_MULTIPLIER',
1417: X_TokenName1 => NULL,
1418: X_TokenName2 => NULL,
1419: X_TokenName3 => NULL,

Line 1444: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',

1440: X_Batch_id => NULL,
1441: X_Interface_Header_Id => p_interface_header_id,
1442: X_Interface_Line_id => p_interface_line_id,
1443: X_Error_message_name => 'PO_PDOI_SVC_NO_MULTIPLIER',
1444: X_Table_name => 'PO_PRICE_DIFF_INTERFACE',
1445: X_Column_name => 'MULTIPLIER',
1446: X_TokenName1 => NULL,
1447: X_TokenName2 => NULL,
1448: X_TokenName3 => NULL,

Line 1468: UPDATE PO_PRICE_DIFF_INTERFACE

1464:
1465: l_progress := '090';
1466:
1467: IF (l_error_flag = 'Y') THEN
1468: UPDATE PO_PRICE_DIFF_INTERFACE
1469: SET process_status = 'REJECTED'
1470: WHERE price_diff_interface_id = l_price_diff_record.price_diff_interface_id;
1471: ELSE
1472:

Line 1475: UPDATE PO_PRICE_DIFF_INTERFACE

1471: ELSE
1472:
1473: l_price_diff_num := l_price_diff_num + 1;
1474:
1475: UPDATE PO_PRICE_DIFF_INTERFACE
1476: SET process_status = 'ACCEPTED',
1477: price_differential_num = l_price_diff_num,
1478: entity_type = NVL(entity_type, p_entity_type)
1479: WHERE price_diff_interface_id = l_price_diff_record.price_diff_interface_id;