APPS.ASO_SUP_RESPONSE_PKG dependencies on ASO_SUP_RESPONSE_PKG

Line 1: Package Body ASO_SUP_RESPONSE_PKG AS

1: Package Body ASO_SUP_RESPONSE_PKG AS
2: /* $Header: asospreb.pls 120.4 2006/05/22 22:59:13 skulkarn ship $*/
3:
4: /* procedure to insert INSERT_ROW */
5:

Line 566: ASO_SUP_RESPONSE_PKG.UPDATE_ROW (

562: if (X_OWNER = 'SEED') then
563: user_id := -1;
564: end if;
565:
566: ASO_SUP_RESPONSE_PKG.UPDATE_ROW (
567: P_RESPONSE_ID => P_RESPONSE_ID,
568: P_LAST_UPDATE_DATE => sysdate,
569: P_LAST_UPDATED_BY => user_id,
570: P_LAST_UPDATE_LOGIN => 0,

Line 600: ASO_SUP_RESPONSE_PKG.INSERT_ROW (

596: exception
597:
598: when NO_DATA_FOUND then
599:
600: ASO_SUP_RESPONSE_PKG.INSERT_ROW (
601: PX_ROWID => row_id,
602: PX_RESPONSE_ID => L_RESPONSE_ID,
603: P_CREATION_DATE => sysdate,
604: P_CREATED_BY => user_id,

Line 715: ASO_SUP_RESPONSE_PKG.TRANSLATE_ROW (

711: and response_id = P_RESPONSE_ID;
712:
713: begin
714: if (P_UPLOAD_MODE = 'NLS') then
715: ASO_SUP_RESPONSE_PKG.TRANSLATE_ROW (
716: P_RESPONSE_ID => P_RESPONSE_ID,
717: P_RESPONSE_NAME => P_RESPONSE_NAME,
718: P_DESCRIPTION => P_DESCRIPTION,
719: X_OWNER => P_OWNER);

Line 731: ASO_SUP_RESPONSE_PKG.UPDATE_ROW (

727: fetch get_response_id into l_RESPONSE_ID;
728: if get_response_id%FOUND THEN
729: -- THIS MEANS RESPONSE ALREADY EXISTS
730: --WHERE RESPONSE_NAME like P_RESPONSE_NAME;
731: ASO_SUP_RESPONSE_PKG.UPDATE_ROW (
732: P_RESPONSE_ID => P_RESPONSE_ID,
733: P_LAST_UPDATE_DATE => sysdate ,
734: P_LAST_UPDATED_BY => l_user_id ,
735: P_LAST_UPDATE_LOGIN => l_user_id ,

Line 764: ASO_SUP_RESPONSE_PKG.INSERT_ROW (

760: exit;
761: elsif get_response_id%NOTFOUND THEN
762: -- this means this is a new response
763: L_RESPONSE_ID := P_RESPONSE_ID;
764: ASO_SUP_RESPONSE_PKG.INSERT_ROW (
765: PX_ROWID => row_id,
766: PX_RESPONSE_ID => L_RESPONSE_ID,
767: P_CREATION_DATE => sysdate ,
768: P_CREATED_BY => l_user_id ,

Line 881: END; -- Package Body ASO_SUP_RESPONSE_PKG

877: end if;
878: end if; -- end if for the NLS condition check
879: END LOAD_SEED_ROW;
880:
881: END; -- Package Body ASO_SUP_RESPONSE_PKG