APPS.ASO_SUP_TEMPLATE_PKG dependencies on ASO_SUP_TEMPLATE_PKG

Line 1: Package Body ASO_SUP_TEMPLATE_PKG AS

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

Line 594: ASO_SUP_TEMPLATE_PKG.UPDATE_ROW (

590: if (X_OWNER = 'SEED') then
591: user_id := -1;
592: end if;
593:
594: ASO_SUP_TEMPLATE_PKG.UPDATE_ROW (
595: P_TEMPLATE_ID => P_TEMPLATE_ID,
596: P_LAST_UPDATE_DATE => sysdate,
597: P_LAST_UPDATED_BY => user_id,
598: P_LAST_UPDATE_LOGIN => 0,

Line 630: ASO_SUP_TEMPLATE_PKG.INSERT_ROW (

626: exception
627:
628: when NO_DATA_FOUND then
629:
630: ASO_SUP_TEMPLATE_PKG.INSERT_ROW (
631: PX_ROWID => row_id,
632: PX_TEMPLATE_ID => L_TEMPLATE_ID,
633: P_CREATION_DATE => sysdate,
634: P_CREATED_BY => user_id,

Line 737: ASO_SUP_TEMPLATE_PKG.TRANSLATE_ROW (

733: WHERE TEMPLATE_ID = PX_TEMPLATE_ID;
734: BEGIN
735: if (P_UPLOAD_MODE = 'NLS') then
736:
737: ASO_SUP_TEMPLATE_PKG.TRANSLATE_ROW (
738: P_TEMPLATE_ID => PX_TEMPLATE_ID ,
739: P_TEMPLATE_NAME => P_TEMPLATE_NAME,
740: P_DESCRIPTION => P_DESCRIPTION,
741: X_OWNER => P_OWNER);

Line 752: ASO_SUP_TEMPLATE_PKG.UPDATE_ROW (

748: loop
749: fetch get_templates into l_template_id;
750: if get_templates%FOUND THEN
751: -- this means template already exists
752: ASO_SUP_TEMPLATE_PKG.UPDATE_ROW (
753: P_TEMPLATE_ID => PX_TEMPLATE_ID,
754: P_LAST_UPDATE_DATE => sysdate ,
755: P_LAST_UPDATED_BY => fnd_load_util.owner_id(P_OWNER) ,
756: P_LAST_UPDATE_LOGIN => fnd_load_util.owner_id(P_OWNER) ,

Line 787: ASO_SUP_TEMPLATE_PKG.INSERT_ROW (

783: exit;
784: elsif get_templates%NOTFOUND THEN
785: -- this means this is a new template
786: l_TEMPLATE_ID := PX_TEMPLATE_ID;
787: ASO_SUP_TEMPLATE_PKG.INSERT_ROW (
788: PX_ROWID => row_id,
789: PX_TEMPLATE_ID => l_TEMPLATE_ID,
790: P_CREATION_DATE => sysdate ,
791: P_CREATED_BY => fnd_load_util.owner_id(P_OWNER) ,

Line 828: END; -- Package Body ASO_SUP_TEMPLATE_PKG

824: close get_templates;
825: end if;
826: end if; -- end if the NLS check
827: END LOAD_SEED_ROW;
828: END; -- Package Body ASO_SUP_TEMPLATE_PKG