APPS.ECE_SPSO_TRANS2 dependencies on ECE_SPSO_ITEM_DET

Line 170: FROM ece_spso_item_det

166:
167: BEGIN
168: SELECT max(schedule_item_detail_sequence)
169: INTO x_item_detail_sequence
170: FROM ece_spso_item_det
171: WHERE schedule_id = rec_item.schedule_id
172: AND schedule_item_id= rec_item.schedule_item_id;
173: EXCEPTION
174: WHEN NO_DATA_FOUND THEN

Line 1116: INSERT INTO ECE_SPSO_ITEM_DET

1112: xProgress := 'SPSO2B-10-1210';
1113:
1114:
1115: --DBMS_OUTPUT.PUT_LINE('LN7 '||sqlcode);
1116: INSERT INTO ECE_SPSO_ITEM_DET
1117: (
1118: COMMUNICATION_METHOD ,
1119: TRANSACTION_TYPE ,
1120:

Line 1147: ece_spso_item_det_s.nextval

1143: TO_DATE(tbl_end(1), 'YYYY/MM/DD'),
1144: NVL(TO_NUMBER(tbl_for(1)),0),
1145: NVL(TO_NUMBER(tbl_rel(1)),0),
1146: NVL(TO_NUMBER(tbl_tot(1)),0),
1147: ece_spso_item_det_s.nextval
1148: );
1149:
1150: Bug 1742567
1151: p_communication_method,

Line 1156: ece_spso_item_det_s.currval

1152: p_transaction_type,
1153:
1154:
1155: SELECT
1156: ece_spso_item_det_s.currval
1157: INTO
1158: l_transaction_number
1159: FROM
1160: dual;

Line 1195: INSERT INTO ECE_SPSO_ITEM_DET

1191: xProgress := 'SPSO2B-10-1230';
1192:
1193:
1194: --DBMS_OUTPUT.PUT_LINE('LN9 '||i||sqlcode);
1195: INSERT INTO ECE_SPSO_ITEM_DET
1196: (
1197: /* COMMUNICATION_METHOD ,
1198: TRANSACTION_TYPE ,
1199: */

Line 1226: ece_spso_item_det_s.nextval

1222: TO_DATE(tbl_end(i), 'YYYY/MM/DD'),
1223: NVL(TO_NUMBER(tbl_for(i)),0),
1224: NVL(TO_NUMBER(tbl_rel(i)),0),
1225: NVL(TO_NUMBER(tbl_tot(i)),0),
1226: ece_spso_item_det_s.nextval
1227: );
1228:
1229: /*Bug 1742567
1230: p_communication_method,

Line 1235: ECE_SPSO_ITEM_DET_S.currval

1231: p_transaction_type,
1232: */
1233:
1234: SELECT
1235: ECE_SPSO_ITEM_DET_S.currval
1236: INTO
1237: l_transaction_number
1238: FROM
1239: dual;