APPS.GMS_MULTI_FUNDING dependencies on PA_AGREEMENTS

Line 1574: PA_AGREEMENTS_PKG.INSERT_ROW(

1570: BEGIN
1571:
1572: -- Bug 1672982
1573:
1574: PA_AGREEMENTS_PKG.INSERT_ROW(
1575:
1576: X_ROWID => St_Row_Id,
1577: X_AGREEMENT_ID => St_Agreement_Id,
1578: X_CUSTOMER_ID => X_Customer_Id,

Line 1650: PA_AGREEMENTS

1646: rowid
1647: INTO
1648: X_Row_Id
1649: FROM
1650: PA_AGREEMENTS
1651: WHERE
1652: AGREEMENT_ID = X_Agreement_Id;
1653: EXCEPTION
1654: WHEN NO_DATA_FOUND THEN

Line 1696: PA_AGREEMENTS_PKG.DELETE_ROW( X_ROWID => X_Row_Id); -- Bug 1672982

1692: p_data => ERRBUF );
1693:
1694: Elsif Check_Funding_Exists = 0 THEN
1695: RETCODE := 'S';
1696: PA_AGREEMENTS_PKG.DELETE_ROW( X_ROWID => X_Row_Id); -- Bug 1672982
1697: END IF;
1698: END;
1699: -- Added Exception for Bug:2662848
1700: EXCEPTION

Line 1898: Store_agreement_currency_code PA_AGREEMENTS.agreement_currency_code%type; -- Bug 2475640

1894: Store_Agreement_Type VARCHAR2(30);
1895: Store_Revenue_Limit_Flag VARCHAR2(1);
1896: Store_Invoice_Limit_Flag VARCHAR2(1); /*Bug 6642901*/
1897: Store_Amount NUMBER(22,5);
1898: Store_agreement_currency_code PA_AGREEMENTS.agreement_currency_code%type; -- Bug 2475640
1899:
1900: --p_msg_count NUMBER;
1901:
1902: BEGIN

Line 1929: PA_AGREEMENTS

1925: Store_Invoice_Limit_Flag, /*Bug 6642901*/
1926: Store_Amount,
1927: Store_agreement_currency_code -- Bug 2475640 : Added for 11.5 PA-J certification.
1928: FROM
1929: PA_AGREEMENTS
1930: WHERE
1931: AGREEMENT_ID = X_Agreement_Id;
1932: EXCEPTION
1933: WHEN NO_DATA_FOUND THEN

Line 1963: PA_AGREEMENTS_PKG.UPDATE_ROW (

1959: Store_Amount := (Store_Amount + X_Amount);
1960:
1961: -- Bug 1672982
1962:
1963: PA_AGREEMENTS_PKG.UPDATE_ROW (
1964: X_ROWID => Store_Row_Id,
1965: X_AGREEMENT_ID => X_AGREEMENT_ID,
1966: X_CUSTOMER_ID => Store_Customer_Id,
1967: X_AGREEMENT_NUM => Store_Agreement_Num,

Line 3632: PA_AGREEMENTS

3628: revenue_limit_flag
3629: INTO
3630: St_Revenue_Limit_Flag
3631: FROM
3632: PA_AGREEMENTS
3633: WHERE
3634: agreement_id = X_Agreement_Id;
3635: END ;
3636: --dbms_output.put_line('Got after SELECT of Revenue Limit Flag ');