133: --| OKS_INS_PVT | | | | | |X |
134: --+---------------------------------+---+---+---+---+---+----------------------+
135: --| CSI_ITEM_INSTANCES | X | | | | | |
136: --+---------------------------------+---+---+---+---+---+----------------------+
137: --| OKS_INST_HIST_DETAILS | | X | | | | |
138: --+---------------------------------+---+---+---+---+---+----------------------+
139:
140: l_hdr_id NUMBER;
141: l_line_id NUMBER;
7211: -- create instance history details
7212:
7213:
7214: FORALL i IN subline_id.FIRST .. subline_id.LAST
7215: INSERT INTO oks_inst_hist_details
7216: (ID,
7217: ins_id,
7218: transaction_date,
7219: transaction_type,
7735: -- create instance history details
7736: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');
7737:
7738: FORALL i IN subline_id.FIRST .. subline_id.LAST
7739: INSERT INTO oks_inst_hist_details
7740: (ID,
7741: ins_id,
7742: transaction_date,
7743: transaction_type,
7839:
7840: CLOSE get_inst_hist_csr;
7841: */
7842: FORALL i IN new_subline_id.FIRST .. new_subline_id.LAST
7843: INSERT INTO oks_inst_hist_details
7844: (ID,
7845: ins_id,
7846: transaction_date,
7847: transaction_type,
8233: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');
8234:
8235: --- create instance history details
8236: FORALL i IN subline_id.FIRST .. subline_id.LAST
8237: INSERT INTO oks_inst_hist_details
8238: (ID,
8239: ins_id,
8240: transaction_date,
8241: transaction_type,
8568: fnd_file.put_line(fnd_file.log,'(OKS) -> Instance History created successfully');
8569:
8570: --- create instance history details
8571: FORALL i IN subline_id.FIRST .. subline_id.LAST
8572: INSERT INTO oks_inst_hist_details
8573: (ID,
8574: ins_id,
8575: transaction_date,
8576: transaction_type,