DBA Data[Home] [Help]

APPS.OZF_APPROVAL_PVT dependencies on WF_PARAMETER_T

Line 1043: l_param WF_PARAMETER_T;

1039: l_resp_appl_id VARCHAR2(255) := p_resp_appl_id;
1040: l_resp_id VARCHAR2(255) := p_resp_id;
1041: l_security_group_id VARCHAR2(255) := p_security_group_id;
1042: l_org_id VARCHAR2(255) := p_org_id;
1043: l_param WF_PARAMETER_T;
1044: l_rang NUMBER;
1045: BEGIN
1046: l_rang := 0;
1047:

Line 1052: l_param := WF_PARAMETER_T( NULL, NULL );

1048: IF l_user_id IS NULL THEN
1049: l_user_id := fnd_profile.value('USER_ID');
1050: END IF;
1051:
1052: l_param := WF_PARAMETER_T( NULL, NULL );
1053: -- fill the parameters list
1054: x_list.extend;
1055: l_param.SetName('USER_ID');
1056: l_param.SetValue(l_user_id);

Line 1064: l_param := WF_PARAMETER_T( NULL, NULL );

1060: IF l_resp_id IS NULL THEN
1061: l_resp_id := fnd_profile.value('RESP_ID');
1062: END IF;
1063:
1064: l_param := WF_PARAMETER_T( NULL, NULL );
1065: -- fill the parameters list
1066: x_list.extend;
1067: l_param.SetName('RESP_ID');
1068: l_param.SetValue(l_resp_id);

Line 1076: l_param := WF_PARAMETER_T( NULL, NULL );

1072: IF l_resp_appl_id IS NULL THEN
1073: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
1074: END IF;
1075:
1076: l_param := WF_PARAMETER_T( NULL, NULL );
1077: -- fill the parameters list
1078: x_list.extend;
1079: l_param.SetName('RESP_APPL_ID');
1080: l_param.SetValue(l_resp_appl_id);

Line 1087: l_param := WF_PARAMETER_T( NULL, NULL );

1083:
1084: IF l_security_group_id IS NULL THEN
1085: l_security_group_id := fnd_profile.value('SECURITY_GROUP_ID');
1086: END IF;
1087: l_param := WF_PARAMETER_T( NULL, NULL );
1088: -- fill the parameters list
1089: x_list.extend;
1090: l_param.SetName('SECURITY_GROUP_ID');
1091: l_param.SetValue(l_security_group_id);

Line 1099: l_param := WF_PARAMETER_T( NULL, NULL );

1095: IF l_org_id IS NULL THEN
1096: l_org_id := fnd_profile.value('ORG_ID');
1097: END IF;
1098:
1099: l_param := WF_PARAMETER_T( NULL, NULL );
1100: -- fill the parameters list
1101: x_list.extend;
1102: l_param.SetName('ORG_ID');
1103: l_param.SetValue(l_org_id );

Line 1135: l_parameter_t wf_parameter_t := wf_parameter_t(null, null);

1131: l_item_key VARCHAR2(240);
1132: l_event VARCHAR2(240);
1133:
1134: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1135: l_parameter_t wf_parameter_t := wf_parameter_t(null, null);
1136:
1137: BEGIN
1138:
1139: SAVEPOINT Raise_Event_PVT;

Line 2863: l_parameter_t wf_parameter_t := wf_parameter_t(null, null);

2859: l_api_version CONSTANT number := 1.0;
2860: l_item_key VARCHAR2(240);
2861: l_event VARCHAR2(240);
2862: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
2863: l_parameter_t wf_parameter_t := wf_parameter_t(null, null);
2864: l_sd_event_name VARCHAR2(240) := 'oracle.apps.ozf.request.ShipDebit.approval';
2865:
2866: BEGIN
2867: SAVEPOINT Raise_SD_Event;