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_REQIMP_PKG dependencies on GL_CODE_COMBINATIONS

Line 951: gl_code_combinations.code_combination_id%TYPE,

947: varchar2,
948: x_transaction_id IN
949: po_requisitions_interface.transaction_id%TYPE,
950: x_ccid IN
951: gl_code_combinations.code_combination_id%TYPE,
952: x_segment IN
953: gl_code_combinations.segment1%TYPE)
954: RETURN gl_code_combinations.segment1%TYPE IS
955:

Line 953: gl_code_combinations.segment1%TYPE)

949: po_requisitions_interface.transaction_id%TYPE,
950: x_ccid IN
951: gl_code_combinations.code_combination_id%TYPE,
952: x_segment IN
953: gl_code_combinations.segment1%TYPE)
954: RETURN gl_code_combinations.segment1%TYPE IS
955:
956: l_value gl_code_combinations.segment1%TYPE;
957:

Line 954: RETURN gl_code_combinations.segment1%TYPE IS

950: x_ccid IN
951: gl_code_combinations.code_combination_id%TYPE,
952: x_segment IN
953: gl_code_combinations.segment1%TYPE)
954: RETURN gl_code_combinations.segment1%TYPE IS
955:
956: l_value gl_code_combinations.segment1%TYPE;
957:
958: BEGIN

Line 956: l_value gl_code_combinations.segment1%TYPE;

952: x_segment IN
953: gl_code_combinations.segment1%TYPE)
954: RETURN gl_code_combinations.segment1%TYPE IS
955:
956: l_value gl_code_combinations.segment1%TYPE;
957:
958: BEGIN
959:
960: IF SUBSTR(x_segment,1,9) = 'SEGMENT30' THEN

Line 963: FROM gl_code_combinations

959:
960: IF SUBSTR(x_segment,1,9) = 'SEGMENT30' THEN
961: SELECT nvl(segment30,'!@')
962: INTO l_value
963: FROM gl_code_combinations
964: WHERE code_combination_id = x_ccid ;
965: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT29' THEN
966: SELECT nvl(segment29,'!@')
967: INTO l_value

Line 968: FROM gl_code_combinations

964: WHERE code_combination_id = x_ccid ;
965: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT29' THEN
966: SELECT nvl(segment29,'!@')
967: INTO l_value
968: FROM gl_code_combinations
969: WHERE code_combination_id = x_ccid ;
970: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT28' THEN
971: SELECT nvl(segment28,'!@')
972: INTO l_value

Line 973: FROM gl_code_combinations

969: WHERE code_combination_id = x_ccid ;
970: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT28' THEN
971: SELECT nvl(segment28,'!@')
972: INTO l_value
973: FROM gl_code_combinations
974: WHERE code_combination_id = x_ccid ;
975: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT27' THEN
976: SELECT nvl(segment27,'!@')
977: INTO l_value

Line 978: FROM gl_code_combinations

974: WHERE code_combination_id = x_ccid ;
975: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT27' THEN
976: SELECT nvl(segment27,'!@')
977: INTO l_value
978: FROM gl_code_combinations
979: WHERE code_combination_id = x_ccid ;
980: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT26' THEN
981: SELECT nvl(segment26,'!@')
982: INTO l_value

Line 983: FROM gl_code_combinations

979: WHERE code_combination_id = x_ccid ;
980: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT26' THEN
981: SELECT nvl(segment26,'!@')
982: INTO l_value
983: FROM gl_code_combinations
984: WHERE code_combination_id = x_ccid ;
985: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT25' THEN
986: SELECT nvl(segment25,'!@')
987: INTO l_value

Line 988: FROM gl_code_combinations

984: WHERE code_combination_id = x_ccid ;
985: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT25' THEN
986: SELECT nvl(segment25,'!@')
987: INTO l_value
988: FROM gl_code_combinations
989: WHERE code_combination_id = x_ccid ;
990: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT24' THEN
991: SELECT nvl(segment24,'!@')
992: INTO l_value

Line 993: FROM gl_code_combinations

989: WHERE code_combination_id = x_ccid ;
990: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT24' THEN
991: SELECT nvl(segment24,'!@')
992: INTO l_value
993: FROM gl_code_combinations
994: WHERE code_combination_id = x_ccid ;
995: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT23' THEN
996: SELECT nvl(segment23,'!@')
997: INTO l_value

Line 998: FROM gl_code_combinations

994: WHERE code_combination_id = x_ccid ;
995: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT23' THEN
996: SELECT nvl(segment23,'!@')
997: INTO l_value
998: FROM gl_code_combinations
999: WHERE code_combination_id = x_ccid ;
1000: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT22' THEN
1001: SELECT nvl(segment22,'!@')
1002: INTO l_value

Line 1003: FROM gl_code_combinations

999: WHERE code_combination_id = x_ccid ;
1000: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT22' THEN
1001: SELECT nvl(segment22,'!@')
1002: INTO l_value
1003: FROM gl_code_combinations
1004: WHERE code_combination_id = x_ccid ;
1005: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT21' THEN
1006: SELECT nvl(segment21,'!@')
1007: INTO l_value

Line 1008: FROM gl_code_combinations

1004: WHERE code_combination_id = x_ccid ;
1005: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT21' THEN
1006: SELECT nvl(segment21,'!@')
1007: INTO l_value
1008: FROM gl_code_combinations
1009: WHERE code_combination_id = x_ccid ;
1010: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT20' THEN
1011: SELECT nvl(segment20,'!@')
1012: INTO l_value

Line 1013: FROM gl_code_combinations

1009: WHERE code_combination_id = x_ccid ;
1010: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT20' THEN
1011: SELECT nvl(segment20,'!@')
1012: INTO l_value
1013: FROM gl_code_combinations
1014: WHERE code_combination_id = x_ccid ;
1015: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT19' THEN
1016: SELECT nvl(segment19,'!@')
1017: INTO l_value

Line 1018: FROM gl_code_combinations

1014: WHERE code_combination_id = x_ccid ;
1015: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT19' THEN
1016: SELECT nvl(segment19,'!@')
1017: INTO l_value
1018: FROM gl_code_combinations
1019: WHERE code_combination_id = x_ccid ;
1020: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT18' THEN
1021: SELECT nvl(segment18,'!@')
1022: INTO l_value

Line 1023: FROM gl_code_combinations

1019: WHERE code_combination_id = x_ccid ;
1020: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT18' THEN
1021: SELECT nvl(segment18,'!@')
1022: INTO l_value
1023: FROM gl_code_combinations
1024: WHERE code_combination_id = x_ccid ;
1025: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT17' THEN
1026: SELECT nvl(segment17,'!@')
1027: INTO l_value

Line 1028: FROM gl_code_combinations

1024: WHERE code_combination_id = x_ccid ;
1025: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT17' THEN
1026: SELECT nvl(segment17,'!@')
1027: INTO l_value
1028: FROM gl_code_combinations
1029: WHERE code_combination_id = x_ccid ;
1030: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT16' THEN
1031: SELECT nvl(segment16,'!@')
1032: INTO l_value

Line 1033: FROM gl_code_combinations

1029: WHERE code_combination_id = x_ccid ;
1030: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT16' THEN
1031: SELECT nvl(segment16,'!@')
1032: INTO l_value
1033: FROM gl_code_combinations
1034: WHERE code_combination_id = x_ccid ;
1035: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT15' THEN
1036: SELECT nvl(segment15,'!@')
1037: INTO l_value

Line 1038: FROM gl_code_combinations

1034: WHERE code_combination_id = x_ccid ;
1035: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT15' THEN
1036: SELECT nvl(segment15,'!@')
1037: INTO l_value
1038: FROM gl_code_combinations
1039: WHERE code_combination_id = x_ccid ;
1040: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT14' THEN
1041: SELECT nvl(segment14,'!@')
1042: INTO l_value

Line 1043: FROM gl_code_combinations

1039: WHERE code_combination_id = x_ccid ;
1040: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT14' THEN
1041: SELECT nvl(segment14,'!@')
1042: INTO l_value
1043: FROM gl_code_combinations
1044: WHERE code_combination_id = x_ccid ;
1045: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT13' THEN
1046: SELECT nvl(segment13,'!@')
1047: INTO l_value

Line 1048: FROM gl_code_combinations

1044: WHERE code_combination_id = x_ccid ;
1045: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT13' THEN
1046: SELECT nvl(segment13,'!@')
1047: INTO l_value
1048: FROM gl_code_combinations
1049: WHERE code_combination_id = x_ccid ;
1050: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT12' THEN
1051: SELECT nvl(segment12,'!@')
1052: INTO l_value

Line 1053: FROM gl_code_combinations

1049: WHERE code_combination_id = x_ccid ;
1050: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT12' THEN
1051: SELECT nvl(segment12,'!@')
1052: INTO l_value
1053: FROM gl_code_combinations
1054: WHERE code_combination_id = x_ccid ;
1055: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT11' THEN
1056: SELECT nvl(segment11,'!@')
1057: INTO l_value

Line 1058: FROM gl_code_combinations

1054: WHERE code_combination_id = x_ccid ;
1055: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT11' THEN
1056: SELECT nvl(segment11,'!@')
1057: INTO l_value
1058: FROM gl_code_combinations
1059: WHERE code_combination_id = x_ccid ;
1060: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT10' THEN
1061: SELECT nvl(segment10,'!@')
1062: INTO l_value

Line 1063: FROM gl_code_combinations

1059: WHERE code_combination_id = x_ccid ;
1060: ELSIF SUBSTR(x_segment,1,9) = 'SEGMENT10' THEN
1061: SELECT nvl(segment10,'!@')
1062: INTO l_value
1063: FROM gl_code_combinations
1064: WHERE code_combination_id = x_ccid ;
1065: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT9' THEN
1066: SELECT nvl(segment9,'!@')
1067: INTO l_value

Line 1068: FROM gl_code_combinations

1064: WHERE code_combination_id = x_ccid ;
1065: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT9' THEN
1066: SELECT nvl(segment9,'!@')
1067: INTO l_value
1068: FROM gl_code_combinations
1069: WHERE code_combination_id = x_ccid ;
1070: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT8' THEN
1071: SELECT nvl(segment8,'!@')
1072: INTO l_value

Line 1073: FROM gl_code_combinations

1069: WHERE code_combination_id = x_ccid ;
1070: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT8' THEN
1071: SELECT nvl(segment8,'!@')
1072: INTO l_value
1073: FROM gl_code_combinations
1074: WHERE code_combination_id = x_ccid ;
1075: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT7' THEN
1076: SELECT nvl(segment7,'!@')
1077: INTO l_value

Line 1078: FROM gl_code_combinations

1074: WHERE code_combination_id = x_ccid ;
1075: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT7' THEN
1076: SELECT nvl(segment7,'!@')
1077: INTO l_value
1078: FROM gl_code_combinations
1079: WHERE code_combination_id = x_ccid ;
1080: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT6' THEN
1081: SELECT nvl(segment6,'!@')
1082: INTO l_value

Line 1083: FROM gl_code_combinations

1079: WHERE code_combination_id = x_ccid ;
1080: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT6' THEN
1081: SELECT nvl(segment6,'!@')
1082: INTO l_value
1083: FROM gl_code_combinations
1084: WHERE code_combination_id = x_ccid ;
1085: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT5' THEN
1086: SELECT nvl(segment5,'!@')
1087: INTO l_value

Line 1088: FROM gl_code_combinations

1084: WHERE code_combination_id = x_ccid ;
1085: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT5' THEN
1086: SELECT nvl(segment5,'!@')
1087: INTO l_value
1088: FROM gl_code_combinations
1089: WHERE code_combination_id = x_ccid ;
1090: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT4' THEN
1091: SELECT nvl(segment4,'!@')
1092: INTO l_value

Line 1093: FROM gl_code_combinations

1089: WHERE code_combination_id = x_ccid ;
1090: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT4' THEN
1091: SELECT nvl(segment4,'!@')
1092: INTO l_value
1093: FROM gl_code_combinations
1094: WHERE code_combination_id = x_ccid ;
1095: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT3' THEN
1096: SELECT nvl(segment3,'!@')
1097: INTO l_value

Line 1098: FROM gl_code_combinations

1094: WHERE code_combination_id = x_ccid ;
1095: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT3' THEN
1096: SELECT nvl(segment3,'!@')
1097: INTO l_value
1098: FROM gl_code_combinations
1099: WHERE code_combination_id = x_ccid ;
1100: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT2' THEN
1101: SELECT nvl(segment2,'!@')
1102: INTO l_value

Line 1103: FROM gl_code_combinations

1099: WHERE code_combination_id = x_ccid ;
1100: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT2' THEN
1101: SELECT nvl(segment2,'!@')
1102: INTO l_value
1103: FROM gl_code_combinations
1104: WHERE code_combination_id = x_ccid ;
1105: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT1' THEN
1106: SELECT nvl(segment1,'!@')
1107: INTO l_value

Line 1108: FROM gl_code_combinations

1104: WHERE code_combination_id = x_ccid ;
1105: ELSIF SUBSTR(x_segment,1,8) = 'SEGMENT1' THEN
1106: SELECT nvl(segment1,'!@')
1107: INTO l_value
1108: FROM gl_code_combinations
1109: WHERE code_combination_id = x_ccid ;
1110: ELSE
1111: RAISE l_invalid_segment;
1112: END IF;

Line 1125: l_error_msg := 'AUTOGL ERROR - Segment value in GL_CODE_COMBINATIONS is null';

1121: WHEN l_invalid_segment THEN
1122: l_error_msg := 'AUTOGL ERROR - Incorrect AutoAccounting setup - Invalid Segment';
1123: JA_AU_update_errors(x_rowid,x_transaction_id);
1124: WHEN l_null_segment THEN
1125: l_error_msg := 'AUTOGL ERROR - Segment value in GL_CODE_COMBINATIONS is null';
1126: JA_AU_update_errors(x_rowid,x_transaction_id);
1127: WHEN NO_DATA_FOUND THEN
1128: l_error_msg := 'AUTOGL ERROR - Could not retrieve segment value from GL_CODE_COMBINATIONS.';
1129: JA_AU_update_errors(x_rowid,x_transaction_id);

Line 1128: l_error_msg := 'AUTOGL ERROR - Could not retrieve segment value from GL_CODE_COMBINATIONS.';

1124: WHEN l_null_segment THEN
1125: l_error_msg := 'AUTOGL ERROR - Segment value in GL_CODE_COMBINATIONS is null';
1126: JA_AU_update_errors(x_rowid,x_transaction_id);
1127: WHEN NO_DATA_FOUND THEN
1128: l_error_msg := 'AUTOGL ERROR - Could not retrieve segment value from GL_CODE_COMBINATIONS.';
1129: JA_AU_update_errors(x_rowid,x_transaction_id);
1130: WHEN OTHERS THEN
1131: -- DBMS_OUTPUT.NEW_LINE;
1132: -- DBMS_OUTPUT.PUT('*** ERROR in JA_AU_GET_VALUE ***');

Line 1160: RETURN gl_code_combinations.segment1%TYPE IS

1156: x_subinv_ccid IN
1157: mtl_secondary_inventories.expense_account%TYPE,
1158: x_item_ccid IN
1159: mtl_system_items.expense_account%TYPE)
1160: RETURN gl_code_combinations.segment1%TYPE IS
1161:
1162: l_value gl_code_combinations.segment1%TYPE;
1163:
1164: BEGIN

Line 1162: l_value gl_code_combinations.segment1%TYPE;

1158: x_item_ccid IN
1159: mtl_system_items.expense_account%TYPE)
1160: RETURN gl_code_combinations.segment1%TYPE IS
1161:
1162: l_value gl_code_combinations.segment1%TYPE;
1163:
1164: BEGIN
1165:
1166: IF SUBSTR(x_constant,1,2) = '!~' THEN /* Not a constant */

Line 1214: gl_code_combinations.code_combination_id%TYPE)

1210: varchar2,
1211: x_transaction_id IN
1212: po_requisitions_interface.transaction_id%TYPE,
1213: x_ccid IN
1214: gl_code_combinations.code_combination_id%TYPE)
1215: IS
1216: BEGIN
1217:
1218: UPDATE po_requisitions_interface

Line 1253: -- | GL_CODE_COMBINATIONS for the given item and subinventory. It will store

1249: -- ** Create JA_AU_AUTOACCOUNTING procedure
1250: -- *
1251: -- +=======================================================================+
1252: -- | This procedure will obtain the code_combination_id from the table
1253: -- | GL_CODE_COMBINATIONS for the given item and subinventory. It will store
1254: -- | the code_combination_id in the charge_account_id column of the table
1255: -- | PO_REQUISITIONS_INTERFACE.
1256: -- | Any errors will be flagged by inserting a record in PO_INTERFACE_ERRORS
1257: -- | Possible errors are :

Line 1265: -- | AUTOGL ERROR - Segment value in GL_CODE_COMBINATIONS is null.

1261: -- | AUTOGL ERROR - Subinventory expense_account was NULL.
1262: -- | AUTOGL ERROR - Could not retrieve item expense_account.
1263: -- | AUTOGL ERROR - Item expense_account was NULL.
1264: -- | AUTOGL ERROR - Incorrect AutoAccounting setup - Invalid Table.
1265: -- | AUTOGL ERROR - Segment value in GL_CODE_COMBINATIONS is null.
1266: -- | AUTOGL ERROR - Incorrect AutoAccounting setup - Invalid Segment
1267: -- | AUTOGL ERROR - Could not retrieve segment value from GL_CODE_COMBINATIONS.
1268: -- | AUTOGL ERROR - Update of charge_account_id in po_requisitions_interface
1269: -- | failed.

Line 1267: -- | AUTOGL ERROR - Could not retrieve segment value from GL_CODE_COMBINATIONS.

1263: -- | AUTOGL ERROR - Item expense_account was NULL.
1264: -- | AUTOGL ERROR - Incorrect AutoAccounting setup - Invalid Table.
1265: -- | AUTOGL ERROR - Segment value in GL_CODE_COMBINATIONS is null.
1266: -- | AUTOGL ERROR - Incorrect AutoAccounting setup - Invalid Segment
1267: -- | AUTOGL ERROR - Could not retrieve segment value from GL_CODE_COMBINATIONS.
1268: -- | AUTOGL ERROR - Update of charge_account_id in po_requisitions_interface
1269: -- | failed.
1270: -- | AUTOGL ERROR - Could not obtain or create CODE_COMBINATION_ID
1271: -- +=======================================================================+

Line 1297: l_ccid gl_code_combinations.code_combination_id%TYPE;

1293: l_segment JA_AU_ACCT_DEFAULT_SEGS.segment%TYPE;
1294: l_segvalues fnd_flex_ext.segmentarray;
1295: l_seglength natural := 0;
1296: l_segnumber natural := 0;
1297: l_ccid gl_code_combinations.code_combination_id%TYPE;
1298: l_num_segs number;
1299: l_test_ccid boolean;
1300:
1301:

Line 1354: the segment value from GL_CODE_COMBINATIONS for the specified

1350: END IF;
1351:
1352:
1353: /* Fetch the AutoAccounting definitions a row at a time and retrieve
1354: the segment value from GL_CODE_COMBINATIONS for the specified
1355: segment */
1356: OPEN l_autoaccount_defns;
1357:
1358: LOOP