DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_SET_OF_BOOKS_IT

Line 3338: PA_SET_OF_BOOKS_IT

3334:
3335: -- First Try to Update the Row in the Interface Table
3336:
3337: UPDATE
3338: PA_SET_OF_BOOKS_IT
3339: SET
3340: LAST_UPDATE_DATE = TRUNC(SYSDATE),
3341: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
3342: CREATION_DATE = TRUNC(SYSDATE),

Line 3356: INSERT INTO PA_SET_OF_BOOKS_IT

3352:
3353:
3354: IF (SQL%ROWCOUNT = 0) THEN
3355: -- No row was updated, So Insert a new row into the interface table
3356: INSERT INTO PA_SET_OF_BOOKS_IT
3357: (
3358: SET_OF_BOOK,
3359: LAST_UPDATE_DATE,
3360: LAST_UPDATED_BY,