eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ASO_PA_APR_PUB_W dependencies on FND_API

Line 16: a number := fnd_api.g_miss_num;

12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_PA_APR_PUB_W';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asowpapb.pls';
14:
15: FUNCTION rosetta_g_miss_num_map(n number) RETURN number as
16: a number := fnd_api.g_miss_num;
17: b number := 0-1962.0724;
18: BEGIN
19: IF n=a THEN RETURN b; END IF;
20: IF n=b THEN RETURN a; END IF;

Line 63: l_approvers_list_tbl(i).approval_det_id := FND_API.G_MISS_NUM;

59: FOR i IN 1..l_table_size LOOP
60:
61: IF p_approval_det_id IS NOT NULL THEN
62: IF p_approval_det_id(i)= ROSETTA_G_MISS_NUM THEN
63: l_approvers_list_tbl(i).approval_det_id := FND_API.G_MISS_NUM;
64: ELSE
65: l_approvers_list_tbl(i).approval_det_id := p_approval_det_id(i);
66: END IF;
67: END IF;

Line 70: l_approvers_list_tbl(i).object_approval_id := FND_API.G_MISS_NUM;

66: END IF;
67: END IF;
68: IF p_object_approval_id IS NOT NULL THEN
69: IF p_object_approval_id(i)= ROSETTA_G_MISS_NUM THEN
70: l_approvers_list_tbl(i).object_approval_id := FND_API.G_MISS_NUM;
71: ELSE
72: l_approvers_list_tbl(i).object_approval_id := p_object_approval_id(i);
73: END IF;
74: END IF;

Line 77: l_approvers_list_tbl(i).approver_person_id := FND_API.G_MISS_NUM;

73: END IF;
74: END IF;
75: IF p_approver_person_id IS NOT NULL THEN
76: IF p_approver_person_id(i)= ROSETTA_G_MISS_NUM THEN
77: l_approvers_list_tbl(i).approver_person_id := FND_API.G_MISS_NUM;
78: ELSE
79: l_approvers_list_tbl(i).approver_person_id := p_approver_person_id(i);
80: END IF;
81: END IF;

Line 84: l_approvers_list_tbl(i).approver_user_id := FND_API.G_MISS_NUM;

80: END IF;
81: END IF;
82: IF p_approver_user_id IS NOT NULL THEN
83: IF p_approver_user_id(i)= ROSETTA_G_MISS_NUM THEN
84: l_approvers_list_tbl(i).approver_user_id := FND_API.G_MISS_NUM;
85: ELSE
86: l_approvers_list_tbl(i).approver_user_id := p_approver_user_id(i);
87: END IF;
88: END IF;

Line 91: l_approvers_list_tbl(i).notification_id := FND_API.G_MISS_NUM;

87: END IF;
88: END IF;
89: IF p_notification_id IS NOT NULL THEN
90: IF p_notification_id(i)= ROSETTA_G_MISS_NUM THEN
91: l_approvers_list_tbl(i).notification_id := FND_API.G_MISS_NUM;
92: ELSE
93: l_approvers_list_tbl(i).notification_id := p_notification_id(i);
94: END IF;
95: END IF;

Line 98: l_approvers_list_tbl(i).approver_sequence := FND_API.G_MISS_NUM;

94: END IF;
95: END IF;
96: IF p_approver_sequence IS NOT NULL THEN
97: IF p_approver_sequence(i)= ROSETTA_G_MISS_NUM THEN
98: l_approvers_list_tbl(i).approver_sequence := FND_API.G_MISS_NUM;
99: ELSE
100: l_approvers_list_tbl(i).approver_sequence := p_approver_sequence(i);
101: END IF;
102: END IF;

Line 138: l_approvers_list_tbl(i).action_type_id := FND_API.G_MISS_NUM;

134: l_approvers_list_tbl(i).action_type := p_action_type(i);
135: END IF;
136: IF p_action_type_id IS NOT NULL THEN
137: IF p_action_type_id(i)= ROSETTA_G_MISS_NUM THEN
138: l_approvers_list_tbl(i).action_type_id := FND_API.G_MISS_NUM;
139: ELSE
140: l_approvers_list_tbl(i).action_type_id := p_action_type_id(i);
141: END IF;
142: END IF;

Line 145: l_approvers_list_tbl(i).chain_number := FND_API.G_MISS_NUM;

141: END IF;
142: END IF;
143: IF p_chain_number IS NOT NULL THEN
144: IF p_chain_number(i)= ROSETTA_G_MISS_NUM THEN
145: l_approvers_list_tbl(i).chain_number := FND_API.G_MISS_NUM;
146: ELSE
147: l_approvers_list_tbl(i).chain_number := p_chain_number(i);
148: END IF;
149: END IF;

Line 152: l_approvers_list_tbl(i).occurrence := FND_API.G_MISS_NUM;

148: END IF;
149: END IF;
150: IF p_occurrence IS NOT NULL THEN
151: IF p_occurrence(i)= ROSETTA_G_MISS_NUM THEN
152: l_approvers_list_tbl(i).occurrence := FND_API.G_MISS_NUM;
153: ELSE
154: l_approvers_list_tbl(i).occurrence := p_occurrence(i);
155: END IF;
156: END IF;

Line 162: l_approvers_list_tbl(i).date_sent := FND_API.G_MISS_DATE;

158: l_approvers_list_tbl(i).authority := p_authority(i);
159: END IF;
160: IF p_date_sent IS NOT NULL THEN
161: IF p_date_sent(i)= ROSETTA_G_MISTAKE_DATE THEN
162: l_approvers_list_tbl(i).date_sent := FND_API.G_MISS_DATE;
163: ELSE
164: l_approvers_list_tbl(i).date_sent := p_date_sent(i);
165: END IF;
166: END IF;

Line 169: l_approvers_list_tbl(i).date_received := FND_API.G_MISS_DATE;

165: END IF;
166: END IF;
167: IF p_date_received IS NOT NULL THEN
168: IF p_date_received(i)= ROSETTA_G_MISTAKE_DATE THEN
169: l_approvers_list_tbl(i).date_received := FND_API.G_MISS_DATE;
170: ELSE
171: l_approvers_list_tbl(i).date_received := p_date_received(i);
172: END IF;
173: END IF;

Line 380: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,

376: x_qr_rule_type OUT NOCOPY jtf_varchar2_table_100 ,
377: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
378: x_qr_rule_item_class OUT NOCOPY jtf_varchar2_table_100 ,
379: x_qr_rule_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
380: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
381: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
382: p_application_id IN NUMBER := FND_API.G_MISS_NUM ,
383: p_object_approval_id IN NUMBER := FND_API.G_MISS_NUM ,
384: p_clear_transaction_flag IN VARCHAR2 := fnd_api.g_true,

Line 381: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

377: x_qr_approval_level OUT NOCOPY jtf_varchar2_table_300 ,
378: x_qr_rule_item_class OUT NOCOPY jtf_varchar2_table_100 ,
379: x_qr_rule_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
380: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
381: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
382: p_application_id IN NUMBER := FND_API.G_MISS_NUM ,
383: p_object_approval_id IN NUMBER := FND_API.G_MISS_NUM ,
384: p_clear_transaction_flag IN VARCHAR2 := fnd_api.g_true,
385: p_data_flag IN VARCHAR2 :='X',

Line 382: p_application_id IN NUMBER := FND_API.G_MISS_NUM ,

378: x_qr_rule_item_class OUT NOCOPY jtf_varchar2_table_100 ,
379: x_qr_rule_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
380: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
381: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
382: p_application_id IN NUMBER := FND_API.G_MISS_NUM ,
383: p_object_approval_id IN NUMBER := FND_API.G_MISS_NUM ,
384: p_clear_transaction_flag IN VARCHAR2 := fnd_api.g_true,
385: p_data_flag IN VARCHAR2 :='X',
386: p_api_version_number IN NUMBER := 1 ,

Line 383: p_object_approval_id IN NUMBER := FND_API.G_MISS_NUM ,

379: x_qr_rule_category_desc OUT NOCOPY jtf_varchar2_table_100 ,
380: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
381: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
382: p_application_id IN NUMBER := FND_API.G_MISS_NUM ,
383: p_object_approval_id IN NUMBER := FND_API.G_MISS_NUM ,
384: p_clear_transaction_flag IN VARCHAR2 := fnd_api.g_true,
385: p_data_flag IN VARCHAR2 :='X',
386: p_api_version_number IN NUMBER := 1 ,
387: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

Line 384: p_clear_transaction_flag IN VARCHAR2 := fnd_api.g_true,

380: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
381: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
382: p_application_id IN NUMBER := FND_API.G_MISS_NUM ,
383: p_object_approval_id IN NUMBER := FND_API.G_MISS_NUM ,
384: p_clear_transaction_flag IN VARCHAR2 := fnd_api.g_true,
385: p_data_flag IN VARCHAR2 :='X',
386: p_api_version_number IN NUMBER := 1 ,
387: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
388: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

Line 387: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

383: p_object_approval_id IN NUMBER := FND_API.G_MISS_NUM ,
384: p_clear_transaction_flag IN VARCHAR2 := fnd_api.g_true,
385: p_data_flag IN VARCHAR2 :='X',
386: p_api_version_number IN NUMBER := 1 ,
387: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
388: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
389: x_return_status OUT NOCOPY VARCHAR2 ,
390: x_msg_count OUT NOCOPY NUMBER ,
391: x_msg_data OUT NOCOPY VARCHAR2

Line 388: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

384: p_clear_transaction_flag IN VARCHAR2 := fnd_api.g_true,
385: p_data_flag IN VARCHAR2 :='X',
386: p_api_version_number IN NUMBER := 1 ,
387: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
388: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
389: x_return_status OUT NOCOPY VARCHAR2 ,
390: x_msg_count OUT NOCOPY NUMBER ,
391: x_msg_data OUT NOCOPY VARCHAR2
392: )

Line 489: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

485:
486:
487: PROCEDURE start_papproval_process (
488: p_api_version_number IN NUMBER := 1,
489: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
490: p_commit IN VARCHAR2 := fnd_api.g_false,
491: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
492: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
493: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 490: p_commit IN VARCHAR2 := fnd_api.g_false,

486:
487: PROCEDURE start_papproval_process (
488: p_api_version_number IN NUMBER := 1,
489: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
490: p_commit IN VARCHAR2 := fnd_api.g_false,
491: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
492: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
493: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
494: p_requester_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 491: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,

487: PROCEDURE start_papproval_process (
488: p_api_version_number IN NUMBER := 1,
489: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
490: p_commit IN VARCHAR2 := fnd_api.g_false,
491: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
492: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
493: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
494: p_requester_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
495: p_qa_approval_det_id IN jtf_number_table := NULL,

Line 492: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

488: p_api_version_number IN NUMBER := 1,
489: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
490: p_commit IN VARCHAR2 := fnd_api.g_false,
491: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
492: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
493: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
494: p_requester_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
495: p_qa_approval_det_id IN jtf_number_table := NULL,
496: p_qa_object_approval_id IN jtf_number_table := NULL,

Line 493: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

489: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
490: p_commit IN VARCHAR2 := fnd_api.g_false,
491: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
492: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
493: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
494: p_requester_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
495: p_qa_approval_det_id IN jtf_number_table := NULL,
496: p_qa_object_approval_id IN jtf_number_table := NULL,
497: p_qa_approver_person_id IN jtf_number_table := NULL,

Line 494: p_requester_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,

490: p_commit IN VARCHAR2 := fnd_api.g_false,
491: p_object_id IN NUMBER := FND_API.G_MISS_NUM ,
492: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
493: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
494: p_requester_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
495: p_qa_approval_det_id IN jtf_number_table := NULL,
496: p_qa_object_approval_id IN jtf_number_table := NULL,
497: p_qa_approver_person_id IN jtf_number_table := NULL,
498: p_qa_approver_user_id IN jtf_number_table := NULL,