eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PRECREATE_APPL_PUB dependencies on IGS_SS_APP_REQ_STG

Line 1794: l_SS_ADM_APPL_ID IGS_SS_APP_REQ_STG.SS_ADM_APPL_ID%TYPE;

1790: l_APPL_FEE_STATUS_REC C_FEE_STATUS%ROWTYPE;
1791: l_APPL_FEE_PAY_MET_REC C_FEE_PAYMENT_METHOD%ROWTYPE;
1792:
1793:
1794: l_SS_ADM_APPL_ID IGS_SS_APP_REQ_STG.SS_ADM_APPL_ID%TYPE;
1795: l_PERSON_ID IGS_SS_APP_REQ_STG.PERSON_ID%TYPE;
1796: l_APPLICANT_FEE_TYPE IGS_SS_APP_REQ_STG.APPLICANT_FEE_TYPE%TYPE;
1797: l_APPLICANT_FEE_STATUS IGS_SS_APP_REQ_STG.APPLICANT_FEE_STATUS%TYPE;
1798: l_FEE_DATE IGS_SS_APP_REQ_STG.FEE_DATE%TYPE;

Line 1795: l_PERSON_ID IGS_SS_APP_REQ_STG.PERSON_ID%TYPE;

1791: l_APPL_FEE_PAY_MET_REC C_FEE_PAYMENT_METHOD%ROWTYPE;
1792:
1793:
1794: l_SS_ADM_APPL_ID IGS_SS_APP_REQ_STG.SS_ADM_APPL_ID%TYPE;
1795: l_PERSON_ID IGS_SS_APP_REQ_STG.PERSON_ID%TYPE;
1796: l_APPLICANT_FEE_TYPE IGS_SS_APP_REQ_STG.APPLICANT_FEE_TYPE%TYPE;
1797: l_APPLICANT_FEE_STATUS IGS_SS_APP_REQ_STG.APPLICANT_FEE_STATUS%TYPE;
1798: l_FEE_DATE IGS_SS_APP_REQ_STG.FEE_DATE%TYPE;
1799: l_FEE_PAYMENT_METHOD IGS_SS_APP_REQ_STG.FEE_PAYMENT_METHOD%TYPE;

Line 1796: l_APPLICANT_FEE_TYPE IGS_SS_APP_REQ_STG.APPLICANT_FEE_TYPE%TYPE;

1792:
1793:
1794: l_SS_ADM_APPL_ID IGS_SS_APP_REQ_STG.SS_ADM_APPL_ID%TYPE;
1795: l_PERSON_ID IGS_SS_APP_REQ_STG.PERSON_ID%TYPE;
1796: l_APPLICANT_FEE_TYPE IGS_SS_APP_REQ_STG.APPLICANT_FEE_TYPE%TYPE;
1797: l_APPLICANT_FEE_STATUS IGS_SS_APP_REQ_STG.APPLICANT_FEE_STATUS%TYPE;
1798: l_FEE_DATE IGS_SS_APP_REQ_STG.FEE_DATE%TYPE;
1799: l_FEE_PAYMENT_METHOD IGS_SS_APP_REQ_STG.FEE_PAYMENT_METHOD%TYPE;
1800: l_FEE_AMOUNT IGS_SS_APP_REQ_STG.FEE_AMOUNT%TYPE;

Line 1797: l_APPLICANT_FEE_STATUS IGS_SS_APP_REQ_STG.APPLICANT_FEE_STATUS%TYPE;

1793:
1794: l_SS_ADM_APPL_ID IGS_SS_APP_REQ_STG.SS_ADM_APPL_ID%TYPE;
1795: l_PERSON_ID IGS_SS_APP_REQ_STG.PERSON_ID%TYPE;
1796: l_APPLICANT_FEE_TYPE IGS_SS_APP_REQ_STG.APPLICANT_FEE_TYPE%TYPE;
1797: l_APPLICANT_FEE_STATUS IGS_SS_APP_REQ_STG.APPLICANT_FEE_STATUS%TYPE;
1798: l_FEE_DATE IGS_SS_APP_REQ_STG.FEE_DATE%TYPE;
1799: l_FEE_PAYMENT_METHOD IGS_SS_APP_REQ_STG.FEE_PAYMENT_METHOD%TYPE;
1800: l_FEE_AMOUNT IGS_SS_APP_REQ_STG.FEE_AMOUNT%TYPE;
1801: l_REFERENCE_NUM IGS_SS_APP_REQ_STG.REFERENCE_NUM%TYPE;

Line 1798: l_FEE_DATE IGS_SS_APP_REQ_STG.FEE_DATE%TYPE;

1794: l_SS_ADM_APPL_ID IGS_SS_APP_REQ_STG.SS_ADM_APPL_ID%TYPE;
1795: l_PERSON_ID IGS_SS_APP_REQ_STG.PERSON_ID%TYPE;
1796: l_APPLICANT_FEE_TYPE IGS_SS_APP_REQ_STG.APPLICANT_FEE_TYPE%TYPE;
1797: l_APPLICANT_FEE_STATUS IGS_SS_APP_REQ_STG.APPLICANT_FEE_STATUS%TYPE;
1798: l_FEE_DATE IGS_SS_APP_REQ_STG.FEE_DATE%TYPE;
1799: l_FEE_PAYMENT_METHOD IGS_SS_APP_REQ_STG.FEE_PAYMENT_METHOD%TYPE;
1800: l_FEE_AMOUNT IGS_SS_APP_REQ_STG.FEE_AMOUNT%TYPE;
1801: l_REFERENCE_NUM IGS_SS_APP_REQ_STG.REFERENCE_NUM%TYPE;
1802:

Line 1799: l_FEE_PAYMENT_METHOD IGS_SS_APP_REQ_STG.FEE_PAYMENT_METHOD%TYPE;

1795: l_PERSON_ID IGS_SS_APP_REQ_STG.PERSON_ID%TYPE;
1796: l_APPLICANT_FEE_TYPE IGS_SS_APP_REQ_STG.APPLICANT_FEE_TYPE%TYPE;
1797: l_APPLICANT_FEE_STATUS IGS_SS_APP_REQ_STG.APPLICANT_FEE_STATUS%TYPE;
1798: l_FEE_DATE IGS_SS_APP_REQ_STG.FEE_DATE%TYPE;
1799: l_FEE_PAYMENT_METHOD IGS_SS_APP_REQ_STG.FEE_PAYMENT_METHOD%TYPE;
1800: l_FEE_AMOUNT IGS_SS_APP_REQ_STG.FEE_AMOUNT%TYPE;
1801: l_REFERENCE_NUM IGS_SS_APP_REQ_STG.REFERENCE_NUM%TYPE;
1802:
1803: BEGIN

Line 1800: l_FEE_AMOUNT IGS_SS_APP_REQ_STG.FEE_AMOUNT%TYPE;

1796: l_APPLICANT_FEE_TYPE IGS_SS_APP_REQ_STG.APPLICANT_FEE_TYPE%TYPE;
1797: l_APPLICANT_FEE_STATUS IGS_SS_APP_REQ_STG.APPLICANT_FEE_STATUS%TYPE;
1798: l_FEE_DATE IGS_SS_APP_REQ_STG.FEE_DATE%TYPE;
1799: l_FEE_PAYMENT_METHOD IGS_SS_APP_REQ_STG.FEE_PAYMENT_METHOD%TYPE;
1800: l_FEE_AMOUNT IGS_SS_APP_REQ_STG.FEE_AMOUNT%TYPE;
1801: l_REFERENCE_NUM IGS_SS_APP_REQ_STG.REFERENCE_NUM%TYPE;
1802:
1803: BEGIN
1804: -- Standard begin of API savepoint

Line 1801: l_REFERENCE_NUM IGS_SS_APP_REQ_STG.REFERENCE_NUM%TYPE;

1797: l_APPLICANT_FEE_STATUS IGS_SS_APP_REQ_STG.APPLICANT_FEE_STATUS%TYPE;
1798: l_FEE_DATE IGS_SS_APP_REQ_STG.FEE_DATE%TYPE;
1799: l_FEE_PAYMENT_METHOD IGS_SS_APP_REQ_STG.FEE_PAYMENT_METHOD%TYPE;
1800: l_FEE_AMOUNT IGS_SS_APP_REQ_STG.FEE_AMOUNT%TYPE;
1801: l_REFERENCE_NUM IGS_SS_APP_REQ_STG.REFERENCE_NUM%TYPE;
1802:
1803: BEGIN
1804: -- Standard begin of API savepoint
1805: SAVEPOINT INSERT_STG_FEE_REQ_DET_PUB;

Line 1828: check_length('SS_ADM_APPL_ID', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_SS_ADM_APPL_ID)));

1824: -----------------------
1825: -- Validate all the parameters for their length
1826: -----------------------
1827: -- p_SS_ADM_APPL_ID
1828: check_length('SS_ADM_APPL_ID', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_SS_ADM_APPL_ID)));
1829: -- p_PERSON_ID
1830: check_length('PERSON_ID', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_PERSON_ID)));
1831: -- p_APPLICANT_FEE_TYPE
1832: check_length('APPLICANT_FEE_TYPE', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_APPLICANT_FEE_TYPE)));

Line 1830: check_length('PERSON_ID', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_PERSON_ID)));

1826: -----------------------
1827: -- p_SS_ADM_APPL_ID
1828: check_length('SS_ADM_APPL_ID', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_SS_ADM_APPL_ID)));
1829: -- p_PERSON_ID
1830: check_length('PERSON_ID', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_PERSON_ID)));
1831: -- p_APPLICANT_FEE_TYPE
1832: check_length('APPLICANT_FEE_TYPE', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_APPLICANT_FEE_TYPE)));
1833: -- p_APPLICANT_FEE_STATUS
1834: check_length('APPLICANT_FEE_STATUS', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_APPLICANT_FEE_STATUS)));

Line 1832: check_length('APPLICANT_FEE_TYPE', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_APPLICANT_FEE_TYPE)));

1828: check_length('SS_ADM_APPL_ID', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_SS_ADM_APPL_ID)));
1829: -- p_PERSON_ID
1830: check_length('PERSON_ID', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_PERSON_ID)));
1831: -- p_APPLICANT_FEE_TYPE
1832: check_length('APPLICANT_FEE_TYPE', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_APPLICANT_FEE_TYPE)));
1833: -- p_APPLICANT_FEE_STATUS
1834: check_length('APPLICANT_FEE_STATUS', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_APPLICANT_FEE_STATUS)));
1835: -- p_FEE_PAYMENT_METHOD
1836: check_length('FEE_PAYMENT_METHOD', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_FEE_PAYMENT_METHOD)));

Line 1834: check_length('APPLICANT_FEE_STATUS', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_APPLICANT_FEE_STATUS)));

1830: check_length('PERSON_ID', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_PERSON_ID)));
1831: -- p_APPLICANT_FEE_TYPE
1832: check_length('APPLICANT_FEE_TYPE', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_APPLICANT_FEE_TYPE)));
1833: -- p_APPLICANT_FEE_STATUS
1834: check_length('APPLICANT_FEE_STATUS', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_APPLICANT_FEE_STATUS)));
1835: -- p_FEE_PAYMENT_METHOD
1836: check_length('FEE_PAYMENT_METHOD', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_FEE_PAYMENT_METHOD)));
1837: -- p_FEE_AMOUNT
1838: check_length('FEE_AMOUNT', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_FEE_AMOUNT)));

Line 1836: check_length('FEE_PAYMENT_METHOD', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_FEE_PAYMENT_METHOD)));

1832: check_length('APPLICANT_FEE_TYPE', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_APPLICANT_FEE_TYPE)));
1833: -- p_APPLICANT_FEE_STATUS
1834: check_length('APPLICANT_FEE_STATUS', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_APPLICANT_FEE_STATUS)));
1835: -- p_FEE_PAYMENT_METHOD
1836: check_length('FEE_PAYMENT_METHOD', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_FEE_PAYMENT_METHOD)));
1837: -- p_FEE_AMOUNT
1838: check_length('FEE_AMOUNT', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_FEE_AMOUNT)));
1839: -- p_REFERENCE_NUM
1840: check_length('REFERENCE_NUM', 'IGS_SS_APP_REQ_STG', length(p_REFERENCE_NUM));

Line 1838: check_length('FEE_AMOUNT', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_FEE_AMOUNT)));

1834: check_length('APPLICANT_FEE_STATUS', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_APPLICANT_FEE_STATUS)));
1835: -- p_FEE_PAYMENT_METHOD
1836: check_length('FEE_PAYMENT_METHOD', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_FEE_PAYMENT_METHOD)));
1837: -- p_FEE_AMOUNT
1838: check_length('FEE_AMOUNT', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_FEE_AMOUNT)));
1839: -- p_REFERENCE_NUM
1840: check_length('REFERENCE_NUM', 'IGS_SS_APP_REQ_STG', length(p_REFERENCE_NUM));
1841: ------------------------
1842: -- End of parameter-length validations.

Line 1840: check_length('REFERENCE_NUM', 'IGS_SS_APP_REQ_STG', length(p_REFERENCE_NUM));

1836: check_length('FEE_PAYMENT_METHOD', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_FEE_PAYMENT_METHOD)));
1837: -- p_FEE_AMOUNT
1838: check_length('FEE_AMOUNT', 'IGS_SS_APP_REQ_STG', length(TRUNC(p_FEE_AMOUNT)));
1839: -- p_REFERENCE_NUM
1840: check_length('REFERENCE_NUM', 'IGS_SS_APP_REQ_STG', length(p_REFERENCE_NUM));
1841: ------------------------
1842: -- End of parameter-length validations.
1843: ------------------------
1844:

Line 1971: INSERT INTO IGS_SS_APP_REQ_STG (

1967: IGS_GE_MSG_STACK.ADD;
1968: RAISE FND_API.G_EXC_ERROR;
1969: END IF;
1970:
1971: INSERT INTO IGS_SS_APP_REQ_STG (
1972: SS_APP_REQ_ID,
1973: SS_ADM_APPL_ID,
1974: PERSON_ID,
1975: APPLICANT_FEE_TYPE,

Line 1989: IGS_SS_APP_REQ_STG_S.NEXTVAL,

1985: REFERENCE_NUM
1986: )
1987: VALUES
1988: (
1989: IGS_SS_APP_REQ_STG_S.NEXTVAL,
1990: l_SS_ADM_APPL_ID,
1991: l_PERSON_ID,
1992: l_APPLICANT_FEE_TYPE,
1993: l_APPLICANT_FEE_STATUS,