44: l_created_by NUMBER(15) := NVL(fnd_profile.value('USER_ID'), 1);
45: l_creation_DATE DATE := SYSDATE;
46: l_last_UPDATEd_by NUMBER(15) := NVL(fnd_profile.value('USER_ID'), 1);
47: l_last_UPDATE_DATE DATE := SYSDATE;
48: l_last_UPDATE_login NUMBER(15) := NVL(fnd_global.conc_login_id, 1);
49:
50:
51: BEGIN
52:
570: l_created_by NUMBER(15) := NVL(fnd_profile.value('USER_ID'), 1);
571: l_creation_DATE DATE := SYSDATE;
572: l_last_UPDATEd_by NUMBER(15) := NVL(fnd_profile.value('USER_ID'), 1);
573: l_last_UPDATE_DATE DATE := SYSDATE;
574: l_last_UPDATE_login NUMBER(15) := NVL(fnd_global.conc_login_id, 1);
575:
576:
577: --FLAGS:
578: ----------
1877: l_created_by NUMBER(15) := NVL(fnd_profile.value('USER_ID'), 1);
1878: l_creation_DATE DATE := SYSDATE;
1879: l_last_UPDATEd_by NUMBER(15) := NVL(fnd_profile.value('USER_ID'), 1);
1880: l_last_UPDATE_DATE DATE := SYSDATE;
1881: l_last_UPDATE_login NUMBER(15) := NVL(fnd_global.conc_login_id, 1);
1882:
1883:
1884: CURSOR CUR4(l_TAXPAYERID_C NUMBER) IS
1885: SELECT APINA.INVOICE_ID,