DBA Data[Home] [Help]

APPS.HR_WIP_TXNS dependencies on HR_API

Line 209: If p_new_dml_mode = hr_api.g_varchar2 THEN

205: (p_new_dml_mode IN hr_wip_transactions.dml_mode%TYPE
206: ,p_old_dml_mode IN hr_wip_transactions.dml_mode%TYPE)
207: RETURN hr_wip_transactions.dml_mode%TYPE is
208: begin
209: If p_new_dml_mode = hr_api.g_varchar2 THEN
210: RETURN(p_old_dml_mode);
211: end if;
212: -- a new dml_mode has been specified
213: -- check the dml_mode

Line 249: If p_new_context_display_text = hr_api.g_varchar2

245: ,p_old_context_display_text IN hr_wip_transactions.context_display_text%TYPE)
246: RETURN hr_wip_transactions.context_display_text%TYPE IS
247: begin
248: -- set the correct context_display_text
249: If p_new_context_display_text = hr_api.g_varchar2
250: then
251: -- the context_display_text was not specified
252: RETURN(p_old_context_display_text);
253: else

Line 323: default hr_api.g_varchar2

319: ,p_state IN hr_wip_transactions.state%TYPE
320: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
321: ,p_vo_xml IN VARCHAR2
322: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
323: default hr_api.g_varchar2
324: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
325: default hr_api.g_varchar2
326: )is
327: --

Line 325: default hr_api.g_varchar2

321: ,p_vo_xml IN VARCHAR2
322: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
323: default hr_api.g_varchar2
324: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
325: default hr_api.g_varchar2
326: )is
327: --
328: begin
329: update hr_wip_transactions

Line 495: default hr_api.g_varchar2

491: ,p_current_user_id IN fnd_user.user_id%TYPE
492: ,p_vo_xml IN VARCHAR2
493: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
494: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
495: default hr_api.g_varchar2
496: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
497: default hr_api.g_varchar2
498: ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE
499: )is

Line 497: default hr_api.g_varchar2

493: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
494: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
495: default hr_api.g_varchar2
496: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
497: default hr_api.g_varchar2
498: ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE
499: )is
500: PRAGMA AUTONOMOUS_TRANSACTION;
501: l_creator_user_id hr_wip_transactions.creator_user_id%TYPE;

Line 568: default hr_api.g_varchar2

564: ,p_current_user_id IN fnd_user.user_id%TYPE
565: ,p_vo_xml IN VARCHAR2
566: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
567: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
568: default hr_api.g_varchar2
569: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
570: default hr_api.g_varchar2
571: )is
572: PRAGMA AUTONOMOUS_TRANSACTION;

Line 570: default hr_api.g_varchar2

566: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
567: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
568: default hr_api.g_varchar2
569: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
570: default hr_api.g_varchar2
571: )is
572: PRAGMA AUTONOMOUS_TRANSACTION;
573: l_creator_user_id hr_wip_transactions.creator_user_id%TYPE;
574: l_state hr_wip_transactions.state%TYPE;

Line 712: default hr_api.g_varchar2

708: ,p_item_key IN wf_items.item_key%TYPE
709: ,p_current_user_id IN fnd_user.user_id%TYPE
710: ,p_vo_xml IN VARCHAR2
711: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
712: default hr_api.g_varchar2
713: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
714: default hr_api.g_varchar2
715: )is
716: PRAGMA AUTONOMOUS_TRANSACTION;

Line 714: default hr_api.g_varchar2

710: ,p_vo_xml IN VARCHAR2
711: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
712: default hr_api.g_varchar2
713: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
714: default hr_api.g_varchar2
715: )is
716: PRAGMA AUTONOMOUS_TRANSACTION;
717: l_creator_user_id hr_wip_transactions.creator_user_id%TYPE;
718: l_transaction_id hr_wip_transactions.transaction_id%TYPE;

Line 784: default hr_api.g_varchar2

780: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
781: ,p_current_user_id IN fnd_user.user_id%TYPE
782: ,p_vo_xml IN VARCHAR2
783: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
784: default hr_api.g_varchar2
785: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
786: default hr_api.g_varchar2
787: )is
788: PRAGMA AUTONOMOUS_TRANSACTION;

Line 786: default hr_api.g_varchar2

782: ,p_vo_xml IN VARCHAR2
783: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
784: default hr_api.g_varchar2
785: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
786: default hr_api.g_varchar2
787: )is
788: PRAGMA AUTONOMOUS_TRANSACTION;
789: l_creator_user_id hr_wip_transactions.creator_user_id%TYPE;
790: l_state hr_wip_transactions.state%TYPE;

Line 1072: default hr_api.g_varchar2

1068: ,p_item_key IN wf_items.item_key%TYPE
1069: ,p_state IN hr_wip_transactions.state%TYPE
1070: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
1071: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
1072: default hr_api.g_varchar2
1073: ,p_vo_xml IN VARCHAR2
1074: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
1075: default hr_api.g_varchar2
1076: )is

Line 1075: default hr_api.g_varchar2

1071: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
1072: default hr_api.g_varchar2
1073: ,p_vo_xml IN VARCHAR2
1074: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
1075: default hr_api.g_varchar2
1076: )is
1077: PRAGMA AUTONOMOUS_TRANSACTION;
1078: l_transaction_id hr_wip_transactions.transaction_id%TYPE;
1079: l_dml_mode hr_wip_transactions.dml_mode%TYPE;

Line 1144: default hr_api.g_varchar2

1140: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
1141: ,p_state IN hr_wip_transactions.state%TYPE
1142: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
1143: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
1144: default hr_api.g_varchar2
1145: ,p_vo_xml IN VARCHAR2
1146: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
1147: default hr_api.g_varchar2
1148: )is

Line 1147: default hr_api.g_varchar2

1143: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
1144: default hr_api.g_varchar2
1145: ,p_vo_xml IN VARCHAR2
1146: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
1147: default hr_api.g_varchar2
1148: )is
1149: PRAGMA AUTONOMOUS_TRANSACTION;
1150: l_dml_mode hr_wip_transactions.dml_mode%TYPE;
1151: l_context_display_text hr_wip_transactions.context_display_text%TYPE;