DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE_PO_PVT dependencies on PO_WF_UTIL_PKG

Line 695: l_preparer_id := po_wf_util_pkg.GetItemAttrText ( itemtype => l_itemtype,

691: END IF;
692:
693: IF ( (l_auth_status='PRE-APPROVED') OR (l_auth_status='IN PROCESS') ) THEN
694:
695: l_preparer_id := po_wf_util_pkg.GetItemAttrText ( itemtype => l_itemtype,
696: itemkey => l_itemkey,
697: aname => 'PREPARER_ID');
698:
699: IF (l_preparer_id = p_old_personid) THEN

Line 701: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

697: aname => 'PREPARER_ID');
698:
699: IF (l_preparer_id = p_old_personid) THEN
700:
701: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
702: itemkey => l_itemkey,
703: aname => 'PREPARER_USER_NAME' ,
704: avalue => p_new_username);
705:

Line 706: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

702: itemkey => l_itemkey,
703: aname => 'PREPARER_USER_NAME' ,
704: avalue => p_new_username);
705:
706: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
707: itemkey => l_itemkey,
708: aname => 'PREPARER_DISPLAY_NAME' ,
709: avalue => p_new_user_display_name);
710:

Line 711: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

707: itemkey => l_itemkey,
708: aname => 'PREPARER_DISPLAY_NAME' ,
709: avalue => p_new_user_display_name);
710:
711: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
712: itemkey => l_itemkey,
713: aname => 'PREPARER_ID' ,
714: avalue => p_new_personid);
715:

Line 718: l_buyer_user_id := po_wf_util_pkg.GetItemAttrText ( itemtype => l_itemtype,

714: avalue => p_new_personid);
715:
716: END IF;
717:
718: l_buyer_user_id := po_wf_util_pkg.GetItemAttrText ( itemtype => l_itemtype,
719: itemkey => l_itemkey,
720: aname => 'BUYER_USER_ID');
721:
722: IF (l_buyer_user_id = p_old_buyer_user_id) THEN

Line 724: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

720: aname => 'BUYER_USER_ID');
721:
722: IF (l_buyer_user_id = p_old_buyer_user_id) THEN
723:
724: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
725: itemkey => l_itemkey,
726: aname => 'BUYER_USER_ID' ,
727: avalue => p_new_buyer_user_id);
728:

Line 729: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

725: itemkey => l_itemkey,
726: aname => 'BUYER_USER_ID' ,
727: avalue => p_new_buyer_user_id);
728:
729: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
730: itemkey => l_itemkey,
731: aname => 'BUYER_USER_NAME' ,
732: avalue => p_new_username);
733:

Line 739: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

735: Bug 14078118
736: POXPOPDF uses 'USER_ID' and not 'BUYER_USER_ID', so this will make sure that, even after 'Mass Update' is run to
737: change a terminated buyer, POXPOPDF would not run with the terminated user's USER_ID
738: */
739: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
740: itemkey => l_itemkey,
741: aname => 'USER_ID' ,
742: avalue => p_new_buyer_user_id);
743:

Line 746: l_forward_from_id := po_wf_util_pkg.GetItemAttrText ( itemtype => l_itemtype,

742: avalue => p_new_buyer_user_id);
743:
744: END IF;
745:
746: l_forward_from_id := po_wf_util_pkg.GetItemAttrText ( itemtype => l_itemtype,
747: itemkey => l_itemkey,
748: aname => 'FORWARD_FROM_ID');
749:
750: IF (l_forward_from_id = p_old_personid) THEN

Line 752: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

748: aname => 'FORWARD_FROM_ID');
749:
750: IF (l_forward_from_id = p_old_personid) THEN
751:
752: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
753: itemkey => l_itemkey,
754: aname => 'FORWARD_FROM_DISP_NAME' ,
755: avalue => p_new_user_display_name);
756:

Line 757: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

753: itemkey => l_itemkey,
754: aname => 'FORWARD_FROM_DISP_NAME' ,
755: avalue => p_new_user_display_name);
756:
757: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
758: itemkey => l_itemkey,
759: aname => 'FORWARD_FROM_ID' ,
760: avalue => p_new_personid);
761:

Line 762: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

758: itemkey => l_itemkey,
759: aname => 'FORWARD_FROM_ID' ,
760: avalue => p_new_personid);
761:
762: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
763: itemkey => l_itemkey,
764: aname => 'FORWARD_FROM_USER_NAME' ,
765: avalue => p_new_username);
766:

Line 775: l_buyer_user_id := po_wf_util_pkg.GetItemAttrText ( itemtype => l_itemtype,

771: Added this condition to take care of the case in which Mass Update is run on an 'Approved' PO.
772: */
773: ELSIF (l_auth_status='APPROVED') THEN
774:
775: l_buyer_user_id := po_wf_util_pkg.GetItemAttrText ( itemtype => l_itemtype,
776: itemkey => l_itemkey,
777: aname => 'BUYER_USER_ID');
778:
779: IF (l_buyer_user_id = p_old_buyer_user_id) THEN

Line 781: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

777: aname => 'BUYER_USER_ID');
778:
779: IF (l_buyer_user_id = p_old_buyer_user_id) THEN
780:
781: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
782: itemkey => l_itemkey,
783: aname => 'BUYER_USER_ID' ,
784: avalue => p_new_buyer_user_id);
785:

Line 786: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

782: itemkey => l_itemkey,
783: aname => 'BUYER_USER_ID' ,
784: avalue => p_new_buyer_user_id);
785:
786: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
787: itemkey => l_itemkey,
788: aname => 'BUYER_USER_NAME' ,
789: avalue => p_new_username);
790:

Line 791: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

787: itemkey => l_itemkey,
788: aname => 'BUYER_USER_NAME' ,
789: avalue => p_new_username);
790:
791: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
792: itemkey => l_itemkey,
793: aname => 'USER_ID' ,
794: avalue => p_new_buyer_user_id);
795:

Line 1106: l_preparer_id := po_wf_util_pkg.GetItemAttrText ( itemtype => l_itemtype,

1102:
1103: IF ( (l_auth_status='PRE-APPROVED') OR (l_auth_status='IN PROCESS') ) THEN
1104:
1105:
1106: l_preparer_id := po_wf_util_pkg.GetItemAttrText ( itemtype => l_itemtype,
1107: itemkey => l_itemkey,
1108: aname => 'PREPARER_ID');
1109:
1110: IF (l_preparer_id = p_old_personid) THEN

Line 1112: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

1108: aname => 'PREPARER_ID');
1109:
1110: IF (l_preparer_id = p_old_personid) THEN
1111:
1112: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
1113: itemkey => l_itemkey,
1114: aname => 'PREPARER_USER_NAME' ,
1115: avalue => p_new_username);
1116:

Line 1117: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

1113: itemkey => l_itemkey,
1114: aname => 'PREPARER_USER_NAME' ,
1115: avalue => p_new_username);
1116:
1117: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
1118: itemkey => l_itemkey,
1119: aname => 'PREPARER_DISPLAY_NAME' ,
1120: avalue => p_new_user_display_name);
1121:

Line 1122: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

1118: itemkey => l_itemkey,
1119: aname => 'PREPARER_DISPLAY_NAME' ,
1120: avalue => p_new_user_display_name);
1121:
1122: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
1123: itemkey => l_itemkey,
1124: aname => 'PREPARER_ID' ,
1125: avalue => p_new_personid);
1126:

Line 1129: l_buyer_user_id := po_wf_util_pkg.GetItemAttrText ( itemtype => l_itemtype,

1125: avalue => p_new_personid);
1126:
1127: END IF;
1128:
1129: l_buyer_user_id := po_wf_util_pkg.GetItemAttrText ( itemtype => l_itemtype,
1130: itemkey => l_itemkey,
1131: aname => 'BUYER_USER_ID');
1132:
1133: IF (l_buyer_user_id = p_old_buyer_user_id) THEN

Line 1135: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

1131: aname => 'BUYER_USER_ID');
1132:
1133: IF (l_buyer_user_id = p_old_buyer_user_id) THEN
1134:
1135: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
1136: itemkey => l_itemkey,
1137: aname => 'BUYER_USER_ID' ,
1138: avalue => p_new_buyer_user_id);
1139:

Line 1140: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

1136: itemkey => l_itemkey,
1137: aname => 'BUYER_USER_ID' ,
1138: avalue => p_new_buyer_user_id);
1139:
1140: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
1141: itemkey => l_itemkey,
1142: aname => 'BUYER_USER_NAME' ,
1143: avalue => p_new_username);
1144:

Line 1147: l_forward_from_id := po_wf_util_pkg.GetItemAttrText ( itemtype => l_itemtype,

1143: avalue => p_new_username);
1144:
1145: END IF;
1146:
1147: l_forward_from_id := po_wf_util_pkg.GetItemAttrText ( itemtype => l_itemtype,
1148: itemkey => l_itemkey,
1149: aname => 'FORWARD_FROM_ID');
1150:
1151:

Line 1154: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

1150:
1151:
1152: IF (l_forward_from_id = p_old_personid) THEN
1153:
1154: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
1155: itemkey => l_itemkey,
1156: aname => 'FORWARD_FROM_DISP_NAME' ,
1157: avalue => p_new_user_display_name);
1158:

Line 1159: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

1155: itemkey => l_itemkey,
1156: aname => 'FORWARD_FROM_DISP_NAME' ,
1157: avalue => p_new_user_display_name);
1158:
1159: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
1160: itemkey => l_itemkey,
1161: aname => 'FORWARD_FROM_ID' ,
1162: avalue => p_new_personid);
1163:

Line 1164: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,

1160: itemkey => l_itemkey,
1161: aname => 'FORWARD_FROM_ID' ,
1162: avalue => p_new_personid);
1163:
1164: po_wf_util_pkg.SetItemAttrText ( itemtype => l_itemtype,
1165: itemkey => l_itemkey,
1166: aname => 'FORWARD_FROM_USER_NAME' ,
1167: avalue => p_new_username);
1168: