DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_BGT_TYPES_IT

Line 1967: PA_BGT_TYPES_IT

1963:
1964: -- First Try to Update the Row in the Interface Table
1965:
1966: UPDATE
1967: PA_BGT_TYPES_IT
1968: SET
1969: LAST_UPDATE_DATE = TRUNC(SYSDATE),
1970: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1971: CREATION_DATE = TRUNC(SYSDATE),

Line 1997: INSERT INTO PA_BGT_TYPES_IT

1993: -- Check If Any row was updated
1994:
1995: IF (SQL%ROWCOUNT = 0) THEN
1996: -- No row was updated, So Insert a new row into the interface table
1997: INSERT INTO PA_BGT_TYPES_IT
1998: (
1999: BUDGET_TYPE_CODE,
2000: LAST_UPDATE_DATE,
2001: LAST_UPDATED_BY,