APPS.ASO_SUP_SECTION_PKG dependencies on ASO_SUP_SECTION_PKG

Line 1: Package Body ASO_SUP_SECTION_PKG AS

1: Package Body ASO_SUP_SECTION_PKG AS
2: /* $Header: asospseb.pls 120.4 2006/05/22 23:00:11 skulkarn ship $*/
3:
4: /* procedure to insert INSERT_ROW */
5:

Line 566: ASO_SUP_SECTION_PKG.UPDATE_ROW (

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

Line 600: ASO_SUP_SECTION_PKG.INSERT_ROW (

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

Line 713: ASO_SUP_SECTION_PKG.TRANSLATE_ROW (

709: where section_id = P_SECTION_ID
710: and template_id = P_SECT_TMPL_ID;
711: begin
712: if (P_UPLOAD_MODE = 'NLS') then
713: ASO_SUP_SECTION_PKG.TRANSLATE_ROW (
714: P_SECTION_ID => P_SECTION_ID,
715: P_SECTION_NAME => P_SECTION_NAME,
716: P_DESCRIPTION => P_DESCRIPTION,
717: X_OWNER => P_OWNER);

Line 729: ASO_SUP_SECTION_PKG.UPDATE_ROW (

725: loop
726: fetch get_sections into l_SECTION_ID;
727: if get_sections%FOUND THEN
728: -- this means the section is already created
729: ASO_SUP_SECTION_PKG.UPDATE_ROW (
730: P_SECTION_ID => P_SECTION_ID,
731: P_LAST_UPDATE_DATE => sysdate ,
732: P_LAST_UPDATED_BY => l_user_id ,
733: P_LAST_UPDATE_LOGIN => l_user_id ,

Line 762: ASO_SUP_SECTION_PKG.INSERT_ROW (

758: exit;
759: elsif get_sections%NOTFOUND THEN
760: -- this means this is a new section
761: L_SECTION_ID := P_SECTION_ID;
762: ASO_SUP_SECTION_PKG.INSERT_ROW (
763: PX_ROWID => row_id,
764: PX_SECTION_ID => L_SECTION_ID,
765: P_CREATION_DATE => sysdate ,
766: P_CREATED_BY => l_user_id ,

Line 880: END; -- Package Body ASO_SUP_SECTION_PKG

876: end if; -- end if for the NLS check
877:
878: END LOAD_SEED_ROW;
879:
880: END; -- Package Body ASO_SUP_SECTION_PKG