DBA Data[Home] [Help]

APPS.PN_VAR_DEFAULTS_PKG dependencies on FND_PROFILE

Line 103: NVL(fnd_profile.value('USER_ID'),0),

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,

Line 105: NVL(fnd_profile.value('USER_ID'),0),

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: );

Line 106: NVL(fnd_profile.value('USER_ID'),0),

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:

Line 158: NVL(fnd_profile.value('USER_ID'),0),

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,

Line 160: NVL(fnd_profile.value('USER_ID'),0),

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

Line 161: NVL(fnd_profile.value('USER_ID'),0),

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: );

Line 207: NVL(fnd_profile.value('USER_ID'),0),

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,

Line 209: NVL(fnd_profile.value('USER_ID'),0),

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

Line 210: NVL(fnd_profile.value('USER_ID'),0),

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: );

Line 296: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),

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

Line 298: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),

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:

Line 299: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),

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;

Line 729: NVL(fnd_profile.value('USER_ID'),0),

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,

Line 731: NVL(fnd_profile.value('USER_ID'),0),

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,

Line 732: NVL(fnd_profile.value('USER_ID'),0),

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);

Line 798: x_created_by => NVL(fnd_profile.value('USER_ID'),0),

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);

Line 800: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),

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)

Line 801: x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0),

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

Line 886: NVL(fnd_profile.value('USER_ID'),0),

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

Line 888: NVL(fnd_profile.value('USER_ID'),0),

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:

Line 889: NVL(fnd_profile.value('USER_ID'),0),

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

Line 961: x_created_by => NVL(fnd_profile.value('USER_ID'),0),

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);

Line 963: x_last_updated_by => NVL(fnd_profile.value('USER_ID'),0),

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

Line 964: x_last_update_login => NVL(fnd_profile.value('LOGIN_ID'),0),

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;

Line 1052: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),

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

Line 1054: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),

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

Line 1055: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),0),

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

Line 1808: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),

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: );

Line 1810: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),

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;

Line 1811: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),0)

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:

Line 1855: NVL(fnd_profile.value('USER_ID'),0),

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

Line 1857: NVL(fnd_profile.value('USER_ID'),0),

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;

Line 1858: NVL(fnd_profile.value('USER_ID'),0),

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:

Line 1887: NVL(fnd_profile.value('USER_ID'),0),

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,

Line 1889: NVL(fnd_profile.value('USER_ID'),0),

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,

Line 1890: NVL(fnd_profile.value('USER_ID'),0),

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,

Line 1932: NVL(fnd_profile.value('USER_ID'),0),

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,

Line 1934: NVL(fnd_profile.value('USER_ID'),0),

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,

Line 1935: NVL(fnd_profile.value('USER_ID'),0),

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,

Line 2197: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),

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,

Line 2199: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),

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,

Line 2200: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),0),

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);

Line 2235: LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'),0),

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,

Line 2236: LAST_UPDATE_LOGIN = NVL(fnd_profile.value('USER_ID'),0),

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

Line 2287: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),

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);

Line 2289: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),

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:

Line 2290: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('LOGIN_ID'),0),

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);

Line 2341: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),0),

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);

Line 2343: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),0),

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);

Line 2344: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),0),

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); */