99: c_lrec.AGREEMENT_TEMPLATE_ID,
100: c_lrec.LINE_START_DATE,
101: c_lrec.LINE_END_DATE,
102: sysdate,
103: NVL(fnd_profile.value('USER_ID'),0),
104: sysdate,
105: NVL(fnd_profile.value('USER_ID'),0),
106: NVL(fnd_profile.value('USER_ID'),0),
107: c_lrec.ORG_ID,
101: c_lrec.LINE_END_DATE,
102: sysdate,
103: NVL(fnd_profile.value('USER_ID'),0),
104: sysdate,
105: NVL(fnd_profile.value('USER_ID'),0),
106: NVL(fnd_profile.value('USER_ID'),0),
107: c_lrec.ORG_ID,
108: c_lrec.processed_flag
109: );
102: sysdate,
103: NVL(fnd_profile.value('USER_ID'),0),
104: sysdate,
105: NVL(fnd_profile.value('USER_ID'),0),
106: NVL(fnd_profile.value('USER_ID'),0),
107: c_lrec.ORG_ID,
108: c_lrec.processed_flag
109: );
110:
154: c_hdrec.breakpoint_level,
155: c_hdrec.bkpt_head_template_id,
156: c_hdrec.agreement_template_id,
157: sysdate,
158: NVL(fnd_profile.value('USER_ID'),0),
159: sysdate,
160: NVL(fnd_profile.value('USER_ID'),0),
161: NVL(fnd_profile.value('USER_ID'),0),
162: c_hdrec.ORG_ID,
156: c_hdrec.agreement_template_id,
157: sysdate,
158: NVL(fnd_profile.value('USER_ID'),0),
159: sysdate,
160: NVL(fnd_profile.value('USER_ID'),0),
161: NVL(fnd_profile.value('USER_ID'),0),
162: c_hdrec.ORG_ID,
163: c_hdrec.var_rent_id,
164: c_hdrec.processed_flag
157: sysdate,
158: NVL(fnd_profile.value('USER_ID'),0),
159: sysdate,
160: NVL(fnd_profile.value('USER_ID'),0),
161: NVL(fnd_profile.value('USER_ID'),0),
162: c_hdrec.ORG_ID,
163: c_hdrec.var_rent_id,
164: c_hdrec.processed_flag
165: );
203: c_dtrec.GROUP_BKPT_VOL_START,
204: c_dtrec.GROUP_BKPT_VOL_END,
205: c_dtrec.BKPT_RATE,
206: sysdate,
207: NVL(fnd_profile.value('USER_ID'),0),
208: sysdate,
209: NVL(fnd_profile.value('USER_ID'),0),
210: NVL(fnd_profile.value('USER_ID'),0),
211: C_dtrec.ORG_ID,
205: c_dtrec.BKPT_RATE,
206: sysdate,
207: NVL(fnd_profile.value('USER_ID'),0),
208: sysdate,
209: NVL(fnd_profile.value('USER_ID'),0),
210: NVL(fnd_profile.value('USER_ID'),0),
211: C_dtrec.ORG_ID,
212: C_dtrec.var_rent_id,
213: C_dtrec.processed_flag
206: sysdate,
207: NVL(fnd_profile.value('USER_ID'),0),
208: sysdate,
209: NVL(fnd_profile.value('USER_ID'),0),
210: NVL(fnd_profile.value('USER_ID'),0),
211: C_dtrec.ORG_ID,
212: C_dtrec.var_rent_id,
213: C_dtrec.processed_flag
214: );
292: X_CONSTR_CAT_CODE => c_crec.CONSTR_CAT_CODE,
293: X_TYPE_CODE => c_crec.type_code,
294: X_AMOUNT => c_crec.amount,
295: X_CREATION_DATE => sysdate,
296: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
297: X_LAST_UPDATE_DATE => sysdate,
298: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
299: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),
300: X_ORG_ID => c_crec.ORG_ID
294: X_AMOUNT => c_crec.amount,
295: X_CREATION_DATE => sysdate,
296: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
297: X_LAST_UPDATE_DATE => sysdate,
298: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
299: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),
300: X_ORG_ID => c_crec.ORG_ID
301: );
302:
295: X_CREATION_DATE => sysdate,
296: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
297: X_LAST_UPDATE_DATE => sysdate,
298: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
299: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),
300: X_ORG_ID => c_crec.ORG_ID
301: );
302:
303: END LOOP;
725: c_line_rec.ATTRIBUTE14,
726: c_line_rec.ATTRIBUTE15,
727: c_line_rec.org_id,
728: sysdate,
729: NVL(fnd_profile.value('USER_ID'),0),
730: sysdate,
731: NVL(fnd_profile.value('USER_ID'),0),
732: NVL(fnd_profile.value('USER_ID'),0),
733: c_line_rec.line_template_id,
727: c_line_rec.org_id,
728: sysdate,
729: NVL(fnd_profile.value('USER_ID'),0),
730: sysdate,
731: NVL(fnd_profile.value('USER_ID'),0),
732: NVL(fnd_profile.value('USER_ID'),0),
733: c_line_rec.line_template_id,
734: c_line_rec.agreement_template_id,
735: c_line_rec.line_default_id,
728: sysdate,
729: NVL(fnd_profile.value('USER_ID'),0),
730: sysdate,
731: NVL(fnd_profile.value('USER_ID'),0),
732: NVL(fnd_profile.value('USER_ID'),0),
733: c_line_rec.line_template_id,
734: c_line_rec.agreement_template_id,
735: c_line_rec.line_default_id,
736: l_var_rent_id);
794: x_attribute14 => c_head_rec.ATTRIBUTE14,
795: x_attribute15 => c_head_rec.ATTRIBUTE15,
796: x_org_id => c_head_rec.org_id,
797: x_creation_date => sysdate,
798: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
799: x_last_update_date => sysdate,
800: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
801: x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0),
802: x_bkpt_update_flag => c_head_rec.bkpt_update_flag);
796: x_org_id => c_head_rec.org_id,
797: x_creation_date => sysdate,
798: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
799: x_last_update_date => sysdate,
800: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
801: x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0),
802: x_bkpt_update_flag => c_head_rec.bkpt_update_flag);
803:
804: FOR c_det_rec IN c_bkdets (c_head_rec.bkhd_default_id)
797: x_creation_date => sysdate,
798: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
799: x_last_update_date => sysdate,
800: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
801: x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0),
802: x_bkpt_update_flag => c_head_rec.bkpt_update_flag);
803:
804: FOR c_det_rec IN c_bkdets (c_head_rec.bkhd_default_id)
805: LOOP
882: c_det_rec.ATTRIBUTE14,
883: c_det_rec.ATTRIBUTE15,
884: c_det_rec.org_id,
885: sysdate,
886: NVL(fnd_profile.value('USER_ID'),0),
887: sysdate,
888: NVL(fnd_profile.value('USER_ID'),0),
889: NVL(fnd_profile.value('USER_ID'),0),
890: c_det_rec.annual_basis_amount --03-NOV-2003
884: c_det_rec.org_id,
885: sysdate,
886: NVL(fnd_profile.value('USER_ID'),0),
887: sysdate,
888: NVL(fnd_profile.value('USER_ID'),0),
889: NVL(fnd_profile.value('USER_ID'),0),
890: c_det_rec.annual_basis_amount --03-NOV-2003
891: );
892:
885: sysdate,
886: NVL(fnd_profile.value('USER_ID'),0),
887: sysdate,
888: NVL(fnd_profile.value('USER_ID'),0),
889: NVL(fnd_profile.value('USER_ID'),0),
890: c_det_rec.annual_basis_amount --03-NOV-2003
891: );
892:
893: IF l_bkhd_start_date is NULL OR
957: x_attribute14 => c_head_rec.ATTRIBUTE14,
958: x_attribute15 => c_head_rec.ATTRIBUTE15,
959: x_org_id => c_head_rec.org_id,
960: x_creation_date => sysdate,
961: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
962: x_last_update_date => sysdate,
963: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
964: x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0),
965: x_bkpt_update_flag => c_head_rec.bkpt_update_flag);
959: x_org_id => c_head_rec.org_id,
960: x_creation_date => sysdate,
961: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
962: x_last_update_date => sysdate,
963: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
964: x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0),
965: x_bkpt_update_flag => c_head_rec.bkpt_update_flag);
966: EXCEPTION
967: WHEN OTHERS THEN
960: x_creation_date => sysdate,
961: x_created_by => NVL(fnd_profile.value('USER_ID'),0),
962: x_last_update_date => sysdate,
963: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),
964: x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0),
965: x_bkpt_update_flag => c_head_rec.bkpt_update_flag);
966: EXCEPTION
967: WHEN OTHERS THEN
968: NULL;
1048: X_ATTRIBUTE14 => c_det_rec.ATTRIBUTE14,
1049: X_ATTRIBUTE15 => c_det_rec.ATTRIBUTE15,
1050: X_ORG_ID => c_det_rec.org_id,
1051: X_CREATION_DATE => sysdate,
1052: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1053: X_LAST_UPDATE_DATE => sysdate,
1054: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1055: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),0),
1056: X_ANNUAL_BASIS_AMOUNT => c_det_rec.annual_basis_amount
1050: X_ORG_ID => c_det_rec.org_id,
1051: X_CREATION_DATE => sysdate,
1052: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1053: X_LAST_UPDATE_DATE => sysdate,
1054: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1055: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),0),
1056: X_ANNUAL_BASIS_AMOUNT => c_det_rec.annual_basis_amount
1057: );
1058: EXCEPTION
1051: X_CREATION_DATE => sysdate,
1052: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1053: X_LAST_UPDATE_DATE => sysdate,
1054: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1055: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),0),
1056: X_ANNUAL_BASIS_AMOUNT => c_det_rec.annual_basis_amount
1057: );
1058: EXCEPTION
1059: WHEN OTHERS THEN
1804: X_ATTRIBUTE14 => l_null,
1805: X_ATTRIBUTE15 => l_null,
1806: X_ORG_ID => c_hd.org_id,
1807: X_CREATION_DATE => sysdate,
1808: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1809: X_LAST_UPDATE_DATE => sysdate,
1810: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1811: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),0)
1812: );
1806: X_ORG_ID => c_hd.org_id,
1807: X_CREATION_DATE => sysdate,
1808: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1809: X_LAST_UPDATE_DATE => sysdate,
1810: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1811: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),0)
1812: );
1813:
1814: COMMIT;
1807: X_CREATION_DATE => sysdate,
1808: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1809: X_LAST_UPDATE_DATE => sysdate,
1810: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
1811: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),0)
1812: );
1813:
1814: COMMIT;
1815:
1851: l_null,
1852: l_null,
1853: c_hd.org_id,
1854: sysdate,
1855: NVL(fnd_profile.value('USER_ID'),0),
1856: sysdate,
1857: NVL(fnd_profile.value('USER_ID'),0),
1858: NVL(fnd_profile.value('USER_ID'),0),
1859: NULL --03-NOV-2003
1853: c_hd.org_id,
1854: sysdate,
1855: NVL(fnd_profile.value('USER_ID'),0),
1856: sysdate,
1857: NVL(fnd_profile.value('USER_ID'),0),
1858: NVL(fnd_profile.value('USER_ID'),0),
1859: NULL --03-NOV-2003
1860: );
1861: COMMIT;
1854: sysdate,
1855: NVL(fnd_profile.value('USER_ID'),0),
1856: sysdate,
1857: NVL(fnd_profile.value('USER_ID'),0),
1858: NVL(fnd_profile.value('USER_ID'),0),
1859: NULL --03-NOV-2003
1860: );
1861: COMMIT;
1862:
1883: l_null,
1884: l_null,
1885: X_VAR_RENT_ID,
1886: sysdate,
1887: NVL(fnd_profile.value('USER_ID'),0),
1888: sysdate,
1889: NVL(fnd_profile.value('USER_ID'),0),
1890: NVL(fnd_profile.value('USER_ID'),0),
1891: c_hd.org_id,
1885: X_VAR_RENT_ID,
1886: sysdate,
1887: NVL(fnd_profile.value('USER_ID'),0),
1888: sysdate,
1889: NVL(fnd_profile.value('USER_ID'),0),
1890: NVL(fnd_profile.value('USER_ID'),0),
1891: c_hd.org_id,
1892: l_null,
1893: l_null,
1886: sysdate,
1887: NVL(fnd_profile.value('USER_ID'),0),
1888: sysdate,
1889: NVL(fnd_profile.value('USER_ID'),0),
1890: NVL(fnd_profile.value('USER_ID'),0),
1891: c_hd.org_id,
1892: l_null,
1893: l_null,
1894: l_null,
1928: c_det.bkpt_rate,
1929: l_null,
1930: X_VAR_RENT_ID,
1931: sysdate,
1932: NVL(fnd_profile.value('USER_ID'),0),
1933: sysdate,
1934: NVL(fnd_profile.value('USER_ID'),0),
1935: NVL(fnd_profile.value('USER_ID'),0),
1936: c_hd.org_id,
1930: X_VAR_RENT_ID,
1931: sysdate,
1932: NVL(fnd_profile.value('USER_ID'),0),
1933: sysdate,
1934: NVL(fnd_profile.value('USER_ID'),0),
1935: NVL(fnd_profile.value('USER_ID'),0),
1936: c_hd.org_id,
1937: NULL, --03-NOV-2003
1938: l_null,
1931: sysdate,
1932: NVL(fnd_profile.value('USER_ID'),0),
1933: sysdate,
1934: NVL(fnd_profile.value('USER_ID'),0),
1935: NVL(fnd_profile.value('USER_ID'),0),
1936: c_hd.org_id,
1937: NULL, --03-NOV-2003
1938: l_null,
1939: l_null,
2193: X_ATTRIBUTE14 => line_def_rec.attribute14,
2194: X_ATTRIBUTE15 => line_def_rec.attribute15,
2195: X_ORG_ID => line_def_rec.org_id,
2196: X_CREATION_DATE => sysdate,
2197: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2198: X_LAST_UPDATE_DATE => sysdate,
2199: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2200: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),0),
2201: X_LINE_TEMPLATE_ID => line_def_rec.line_template_id,
2195: X_ORG_ID => line_def_rec.org_id,
2196: X_CREATION_DATE => sysdate,
2197: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2198: X_LAST_UPDATE_DATE => sysdate,
2199: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2200: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),0),
2201: X_LINE_TEMPLATE_ID => line_def_rec.line_template_id,
2202: X_AGREEMENT_TEMPLATE_ID => line_def_rec.agreement_template_id,
2203: X_LINE_DEFAULT_ID => line_def_rec.line_default_id,
2196: X_CREATION_DATE => sysdate,
2197: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2198: X_LAST_UPDATE_DATE => sysdate,
2199: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2200: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),0),
2201: X_LINE_TEMPLATE_ID => line_def_rec.line_template_id,
2202: X_AGREEMENT_TEMPLATE_ID => line_def_rec.agreement_template_id,
2203: X_LINE_DEFAULT_ID => line_def_rec.line_default_id,
2204: X_VAR_RENT_ID => l_var_rent_id);
2231: ATTRIBUTE13 = line_def_rec.attribute13,
2232: ATTRIBUTE14 = line_def_rec.attribute14,
2233: ATTRIBUTE15 = line_def_rec.attribute15,
2234: LAST_UPDATE_DATE = sysdate,
2235: LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'),0),
2236: LAST_UPDATE_LOGIN = NVL(fnd_profile.value('USER_ID'),0),
2237: LINE_TEMPLATE_ID = line_def_rec.line_template_id ,
2238: AGREEMENT_TEMPLATE_ID = line_def_rec.agreement_template_id,
2239: LINE_DEFAULT_ID = line_def_rec.line_default_id,
2232: ATTRIBUTE14 = line_def_rec.attribute14,
2233: ATTRIBUTE15 = line_def_rec.attribute15,
2234: LAST_UPDATE_DATE = sysdate,
2235: LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'),0),
2236: LAST_UPDATE_LOGIN = NVL(fnd_profile.value('USER_ID'),0),
2237: LINE_TEMPLATE_ID = line_def_rec.line_template_id ,
2238: AGREEMENT_TEMPLATE_ID = line_def_rec.agreement_template_id,
2239: LINE_DEFAULT_ID = line_def_rec.line_default_id,
2240: VAR_RENT_ID = l_var_rent_id
2283: X_ATTRIBUTE14 => bkhd_def_rec.attribute14,
2284: X_ATTRIBUTE15 => bkhd_def_rec.attribute15,
2285: X_ORG_ID => bkhd_def_rec.org_id,
2286: X_CREATION_DATE => sysdate,
2287: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2288: X_LAST_UPDATE_DATE => sysdate,
2289: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2290: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),
2291: X_BKPT_UPDATE_FLAG => bkhd_def_rec.bkpt_update_flag);
2285: X_ORG_ID => bkhd_def_rec.org_id,
2286: X_CREATION_DATE => sysdate,
2287: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2288: X_LAST_UPDATE_DATE => sysdate,
2289: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2290: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),
2291: X_BKPT_UPDATE_FLAG => bkhd_def_rec.bkpt_update_flag);
2292:
2293:
2286: X_CREATION_DATE => sysdate,
2287: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2288: X_LAST_UPDATE_DATE => sysdate,
2289: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2290: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),
2291: X_BKPT_UPDATE_FLAG => bkhd_def_rec.bkpt_update_flag);
2292:
2293:
2294: /*dbms_output.put_line('l_bkpt_header_id ' || l_bkpt_header_id);
2337: X_ATTRIBUTE14 => bkdt_def_rec.attribute14,
2338: X_ATTRIBUTE15 => bkdt_def_rec.attribute15,
2339: X_ORG_ID => bkdt_def_rec.org_id,
2340: X_CREATION_DATE => sysdate,
2341: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2342: X_LAST_UPDATE_DATE => sysdate,
2343: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2344: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),0),
2345: X_ANNUAL_BASIS_AMOUNT => bkdt_def_rec.annual_basis_amount);
2339: X_ORG_ID => bkdt_def_rec.org_id,
2340: X_CREATION_DATE => sysdate,
2341: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2342: X_LAST_UPDATE_DATE => sysdate,
2343: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2344: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),0),
2345: X_ANNUAL_BASIS_AMOUNT => bkdt_def_rec.annual_basis_amount);
2346:
2347: /* dbms_output.put_line('l_bkpt_detail_id ' || l_bkpt_detail_id);
2340: X_CREATION_DATE => sysdate,
2341: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2342: X_LAST_UPDATE_DATE => sysdate,
2343: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),
2344: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),0),
2345: X_ANNUAL_BASIS_AMOUNT => bkdt_def_rec.annual_basis_amount);
2346:
2347: /* dbms_output.put_line('l_bkpt_detail_id ' || l_bkpt_detail_id);
2348: dbms_output.put_line('l_line_item_id '||l_line_item_id); */