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.

APPS.OKC_TERMS_MIGRATE_GRP dependencies on DUAL

Line 45: FROM DUAL;

41: -- One Time fetch and cache the current Org.
42: CURSOR CUR_ORG_CSR IS
43: SELECT NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
44: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
45: FROM DUAL;
46:
47:
48: TYPE g_doc_type IS RECORD (
49: DOCUMENT_TYPE OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE,

Line 553: DUAL;

549:
550: CURSOR l_fnd_lobs_nextval_csr IS
551: SELECT fnd_lobs_s.nextval
552: FROM
553: DUAL;
554:
555: CURSOR l_fnd_att_doc_nextval_csr IS
556: SELECT fnd_attached_documents_s.nextval
557: FROM

Line 558: DUAL;

554:
555: CURSOR l_fnd_att_doc_nextval_csr IS
556: SELECT fnd_attached_documents_s.nextval
557: FROM
558: DUAL;
559:
560: CURSOR l_cat_id_csr IS
561: SELECT category_id
562: FROM

Line 1278: DUAL;

1274:
1275: CURSOR l_fnd_lobs_nextval_csr IS
1276: SELECT fnd_lobs_s.nextval
1277: FROM
1278: DUAL;
1279:
1280: CURSOR l_fnd_att_doc_nextval_csr IS
1281: SELECT fnd_attached_documents_s.nextval
1282: FROM

Line 1283: DUAL;

1279:
1280: CURSOR l_fnd_att_doc_nextval_csr IS
1281: SELECT fnd_attached_documents_s.nextval
1282: FROM
1283: DUAL;
1284:
1285: CURSOR l_cat_id_csr(l_category IN VARCHAR2) IS
1286: SELECT category_id
1287: FROM

Line 4280: (SELECT 'NOTIFY_ESCALATION_VALUE' col_name FROM dual WHERE p_deliverable_rec.NOTIFY_ESCALATION_VALUE IS NULL

4276: IF p_deliverable_rec.NOTIFY_ESCALATION_YN = 'Y'
4277: THEN
4278: BEGIN
4279: SELECT col_name INTO l_column_name from
4280: (SELECT 'NOTIFY_ESCALATION_VALUE' col_name FROM dual WHERE p_deliverable_rec.NOTIFY_ESCALATION_VALUE IS NULL
4281: UNION
4282: SELECT 'NOTIFY_ESCALATION_UOM' col_name FROM dual WHERE p_deliverable_rec.NOTIFY_ESCALATION_UOM IS NULL
4283: UNION
4284: SELECT 'ESCALATION_ASSIGNEE' col_name FROM dual WHERE p_deliverable_rec.ESCALATION_ASSIGNEE IS NULL);

Line 4282: SELECT 'NOTIFY_ESCALATION_UOM' col_name FROM dual WHERE p_deliverable_rec.NOTIFY_ESCALATION_UOM IS NULL

4278: BEGIN
4279: SELECT col_name INTO l_column_name from
4280: (SELECT 'NOTIFY_ESCALATION_VALUE' col_name FROM dual WHERE p_deliverable_rec.NOTIFY_ESCALATION_VALUE IS NULL
4281: UNION
4282: SELECT 'NOTIFY_ESCALATION_UOM' col_name FROM dual WHERE p_deliverable_rec.NOTIFY_ESCALATION_UOM IS NULL
4283: UNION
4284: SELECT 'ESCALATION_ASSIGNEE' col_name FROM dual WHERE p_deliverable_rec.ESCALATION_ASSIGNEE IS NULL);
4285: okc_api.set_message (p_app_name => g_app_name,
4286: p_msg_name => 'OKC_I_NOT_NULL',

Line 4284: SELECT 'ESCALATION_ASSIGNEE' col_name FROM dual WHERE p_deliverable_rec.ESCALATION_ASSIGNEE IS NULL);

4280: (SELECT 'NOTIFY_ESCALATION_VALUE' col_name FROM dual WHERE p_deliverable_rec.NOTIFY_ESCALATION_VALUE IS NULL
4281: UNION
4282: SELECT 'NOTIFY_ESCALATION_UOM' col_name FROM dual WHERE p_deliverable_rec.NOTIFY_ESCALATION_UOM IS NULL
4283: UNION
4284: SELECT 'ESCALATION_ASSIGNEE' col_name FROM dual WHERE p_deliverable_rec.ESCALATION_ASSIGNEE IS NULL);
4285: okc_api.set_message (p_app_name => g_app_name,
4286: p_msg_name => 'OKC_I_NOT_NULL',
4287: p_token1 => 'FIELD',
4288: p_token1_value => l_column_name

Line 4302: (SELECT 'NOTIFY_PRIOR_DUE_DATE_UOM' col_name FROM dual WHERE p_deliverable_rec.NOTIFY_PRIOR_DUE_DATE_UOM IS NULL

4298: IF p_deliverable_rec.NOTIFY_PRIOR_DUE_DATE_YN = 'Y'
4299: THEN
4300: BEGIN
4301: SELECT col_name INTO l_column_name from
4302: (SELECT 'NOTIFY_PRIOR_DUE_DATE_UOM' col_name FROM dual WHERE p_deliverable_rec.NOTIFY_PRIOR_DUE_DATE_UOM IS NULL
4303: UNION
4304: SELECT 'NOTIFY_PRIOR_DUE_DATE_VALUE' col_name FROM dual WHERE p_deliverable_rec.NOTIFY_PRIOR_DUE_DATE_VALUE IS NULL
4305: );
4306: okc_api.set_message (p_app_name => g_app_name,

Line 4304: SELECT 'NOTIFY_PRIOR_DUE_DATE_VALUE' col_name FROM dual WHERE p_deliverable_rec.NOTIFY_PRIOR_DUE_DATE_VALUE IS NULL

4300: BEGIN
4301: SELECT col_name INTO l_column_name from
4302: (SELECT 'NOTIFY_PRIOR_DUE_DATE_UOM' col_name FROM dual WHERE p_deliverable_rec.NOTIFY_PRIOR_DUE_DATE_UOM IS NULL
4303: UNION
4304: SELECT 'NOTIFY_PRIOR_DUE_DATE_VALUE' col_name FROM dual WHERE p_deliverable_rec.NOTIFY_PRIOR_DUE_DATE_VALUE IS NULL
4305: );
4306: okc_api.set_message (p_app_name => g_app_name,
4307: p_msg_name => 'OKC_I_NOT_NULL',
4308: p_token1 => 'FIELD',

Line 4428: FROM DUAL

4424:
4425: SELECT column_name
4426: INTO l_column_name
4427: FROM (SELECT 'RECURRING_YN' column_name
4428: FROM DUAL
4429: WHERE p_deliverable_rec.recurring_yn = 'Y'
4430: UNION
4431: SELECT 'RELATIVE_ST_DATE_DURATION' column_name
4432: FROM DUAL

Line 4432: FROM DUAL

4428: FROM DUAL
4429: WHERE p_deliverable_rec.recurring_yn = 'Y'
4430: UNION
4431: SELECT 'RELATIVE_ST_DATE_DURATION' column_name
4432: FROM DUAL
4433: WHERE p_deliverable_rec.relative_st_date_duration IS NOT NULL
4434: UNION
4435: SELECT 'RELATIVE_ST_DATE_UOM' column_name
4436: FROM DUAL

Line 4436: FROM DUAL

4432: FROM DUAL
4433: WHERE p_deliverable_rec.relative_st_date_duration IS NOT NULL
4434: UNION
4435: SELECT 'RELATIVE_ST_DATE_UOM' column_name
4436: FROM DUAL
4437: WHERE p_deliverable_rec.relative_st_date_uom IS NOT NULL
4438: UNION
4439: SELECT 'RELATIVE_ST_DATE_EVENT_ID' column_name
4440: FROM DUAL

Line 4440: FROM DUAL

4436: FROM DUAL
4437: WHERE p_deliverable_rec.relative_st_date_uom IS NOT NULL
4438: UNION
4439: SELECT 'RELATIVE_ST_DATE_EVENT_ID' column_name
4440: FROM DUAL
4441: WHERE p_deliverable_rec.relative_st_date_event_id IS NOT NULL
4442: UNION
4443: SELECT 'RELATIVE_END_DATE_DURATION' column_name
4444: FROM DUAL

Line 4444: FROM DUAL

4440: FROM DUAL
4441: WHERE p_deliverable_rec.relative_st_date_event_id IS NOT NULL
4442: UNION
4443: SELECT 'RELATIVE_END_DATE_DURATION' column_name
4444: FROM DUAL
4445: WHERE p_deliverable_rec.relative_end_date_duration IS NOT NULL
4446: UNION
4447: SELECT 'RELATIVE_END_DATE_UOM' column_name
4448: FROM DUAL

Line 4448: FROM DUAL

4444: FROM DUAL
4445: WHERE p_deliverable_rec.relative_end_date_duration IS NOT NULL
4446: UNION
4447: SELECT 'RELATIVE_END_DATE_UOM' column_name
4448: FROM DUAL
4449: WHERE p_deliverable_rec.relative_end_date_uom IS NOT NULL
4450: UNION
4451: SELECT 'RELATIVE_END_DATE_EVENT_ID' column_name
4452: FROM DUAL

Line 4452: FROM DUAL

4448: FROM DUAL
4449: WHERE p_deliverable_rec.relative_end_date_uom IS NOT NULL
4450: UNION
4451: SELECT 'RELATIVE_END_DATE_EVENT_ID' column_name
4452: FROM DUAL
4453: WHERE p_deliverable_rec.relative_end_date_event_id IS NOT NULL
4454: UNION
4455: SELECT 'REPEATING_DAY_OF_MONTH' column_name
4456: FROM DUAL

Line 4456: FROM DUAL

4452: FROM DUAL
4453: WHERE p_deliverable_rec.relative_end_date_event_id IS NOT NULL
4454: UNION
4455: SELECT 'REPEATING_DAY_OF_MONTH' column_name
4456: FROM DUAL
4457: WHERE p_deliverable_rec.repeating_day_of_month IS NOT NULL
4458: UNION
4459: SELECT 'REPEATING_DAY_OF_WEEK' column_name
4460: FROM DUAL

Line 4460: FROM DUAL

4456: FROM DUAL
4457: WHERE p_deliverable_rec.repeating_day_of_month IS NOT NULL
4458: UNION
4459: SELECT 'REPEATING_DAY_OF_WEEK' column_name
4460: FROM DUAL
4461: WHERE p_deliverable_rec.repeating_day_of_week IS NOT NULL
4462: UNION
4463: SELECT 'REPEATING_FREQUENCY_UOM' column_name
4464: FROM DUAL

Line 4464: FROM DUAL

4460: FROM DUAL
4461: WHERE p_deliverable_rec.repeating_day_of_week IS NOT NULL
4462: UNION
4463: SELECT 'REPEATING_FREQUENCY_UOM' column_name
4464: FROM DUAL
4465: WHERE p_deliverable_rec.repeating_frequency_uom IS NOT NULL
4466: UNION
4467: SELECT 'REPEATING_DURATION' column_name
4468: FROM DUAL

Line 4468: FROM DUAL

4464: FROM DUAL
4465: WHERE p_deliverable_rec.repeating_frequency_uom IS NOT NULL
4466: UNION
4467: SELECT 'REPEATING_DURATION' column_name
4468: FROM DUAL
4469: WHERE p_deliverable_rec.repeating_duration IS NOT NULL
4470: UNION
4471: SELECT 'FIXED_END_DATE' column_name
4472: FROM DUAL

Line 4472: FROM DUAL

4468: FROM DUAL
4469: WHERE p_deliverable_rec.repeating_duration IS NOT NULL
4470: UNION
4471: SELECT 'FIXED_END_DATE' column_name
4472: FROM DUAL
4473: WHERE p_deliverable_rec.fixed_end_date IS NOT NULL)
4474: WHERE ROWNUM = 1;
4475:
4476: okc_api.set_message

Line 4558: FROM DUAL

4554: BEGIN
4555: SELECT column_name
4556: INTO l_column_name
4557: FROM (SELECT 'RELATIVE_END_DATE_DURATION' column_name
4558: FROM DUAL
4559: WHERE p_deliverable_rec.relative_end_date_duration IS NOT NULL
4560: UNION
4561: SELECT 'RELATIVE_END_DATE_UOM' column_name
4562: FROM DUAL

Line 4562: FROM DUAL

4558: FROM DUAL
4559: WHERE p_deliverable_rec.relative_end_date_duration IS NOT NULL
4560: UNION
4561: SELECT 'RELATIVE_END_DATE_UOM' column_name
4562: FROM DUAL
4563: WHERE p_deliverable_rec.relative_end_date_uom IS NOT NULL
4564: UNION
4565: SELECT 'RELATIVE_END_DATE_EVENT_ID' column_name
4566: FROM DUAL

Line 4566: FROM DUAL

4562: FROM DUAL
4563: WHERE p_deliverable_rec.relative_end_date_uom IS NOT NULL
4564: UNION
4565: SELECT 'RELATIVE_END_DATE_EVENT_ID' column_name
4566: FROM DUAL
4567: WHERE p_deliverable_rec.relative_end_date_event_id IS NOT NULL
4568: UNION
4569: SELECT 'REPEATING_DAY_OF_MONTH' column_name
4570: FROM DUAL

Line 4570: FROM DUAL

4566: FROM DUAL
4567: WHERE p_deliverable_rec.relative_end_date_event_id IS NOT NULL
4568: UNION
4569: SELECT 'REPEATING_DAY_OF_MONTH' column_name
4570: FROM DUAL
4571: WHERE p_deliverable_rec.repeating_day_of_month IS NOT NULL
4572: UNION
4573: SELECT 'REPEATING_DAY_OF_WEEK' column_name
4574: FROM DUAL

Line 4574: FROM DUAL

4570: FROM DUAL
4571: WHERE p_deliverable_rec.repeating_day_of_month IS NOT NULL
4572: UNION
4573: SELECT 'REPEATING_DAY_OF_WEEK' column_name
4574: FROM DUAL
4575: WHERE p_deliverable_rec.repeating_day_of_week IS NOT NULL
4576: UNION
4577: SELECT 'REPEATING_FREQUENCY_UOM' column_name
4578: FROM DUAL

Line 4578: FROM DUAL

4574: FROM DUAL
4575: WHERE p_deliverable_rec.repeating_day_of_week IS NOT NULL
4576: UNION
4577: SELECT 'REPEATING_FREQUENCY_UOM' column_name
4578: FROM DUAL
4579: WHERE p_deliverable_rec.repeating_frequency_uom IS NOT NULL
4580: UNION
4581: SELECT 'REPEATING_DURATION' column_name
4582: FROM DUAL

Line 4582: FROM DUAL

4578: FROM DUAL
4579: WHERE p_deliverable_rec.repeating_frequency_uom IS NOT NULL
4580: UNION
4581: SELECT 'REPEATING_DURATION' column_name
4582: FROM DUAL
4583: WHERE p_deliverable_rec.repeating_duration IS NOT NULL
4584: UNION
4585: SELECT 'FIXED_END_DATE' column_name
4586: FROM DUAL

Line 4586: FROM DUAL

4582: FROM DUAL
4583: WHERE p_deliverable_rec.repeating_duration IS NOT NULL
4584: UNION
4585: SELECT 'FIXED_END_DATE' column_name
4586: FROM DUAL
4587: WHERE p_deliverable_rec.fixed_end_date IS NOT NULL
4588: UNION
4589: SELECT 'FIXED_START_DATE' column_name
4590: FROM DUAL

Line 4590: FROM DUAL

4586: FROM DUAL
4587: WHERE p_deliverable_rec.fixed_end_date IS NOT NULL
4588: UNION
4589: SELECT 'FIXED_START_DATE' column_name
4590: FROM DUAL
4591: WHERE p_deliverable_rec.fixed_start_date IS NOT NULL)
4592: WHERE ROWNUM = 1;
4593:
4594: okc_api.set_message

Line 4627: select 'REPEATING_DURATION' column_name from dual where p_deliverable_rec.REPEATING_DURATION is null

4623: -- In all 3.a..3.d cases Repeating information can not be null.
4624: BEGIN
4625: select column_name INTO l_column_name from
4626: (
4627: select 'REPEATING_DURATION' column_name from dual where p_deliverable_rec.REPEATING_DURATION is null
4628: union
4629: select 'REPEATING_FREQUENCY_UOM' column_name from dual where p_deliverable_rec.REPEATING_FREQUENCY_UOM is null
4630: union
4631: select 'REPEATING_DAY_OF_WEEK' column_name from dual where p_deliverable_rec.REPEATING_FREQUENCY_UOM = 'WK' and p_deliverable_rec.REPEATING_DAY_OF_WEEK is null

Line 4629: select 'REPEATING_FREQUENCY_UOM' column_name from dual where p_deliverable_rec.REPEATING_FREQUENCY_UOM is null

4625: select column_name INTO l_column_name from
4626: (
4627: select 'REPEATING_DURATION' column_name from dual where p_deliverable_rec.REPEATING_DURATION is null
4628: union
4629: select 'REPEATING_FREQUENCY_UOM' column_name from dual where p_deliverable_rec.REPEATING_FREQUENCY_UOM is null
4630: union
4631: select 'REPEATING_DAY_OF_WEEK' column_name from dual where p_deliverable_rec.REPEATING_FREQUENCY_UOM = 'WK' and p_deliverable_rec.REPEATING_DAY_OF_WEEK is null
4632: union
4633: select 'REPEATING_DAY_OF_MONTH' column_name from dual where p_deliverable_rec.REPEATING_FREQUENCY_UOM = 'MTH' and p_deliverable_rec.REPEATING_DAY_OF_MONTH is null

Line 4631: select 'REPEATING_DAY_OF_WEEK' column_name from dual where p_deliverable_rec.REPEATING_FREQUENCY_UOM = 'WK' and p_deliverable_rec.REPEATING_DAY_OF_WEEK is null

4627: select 'REPEATING_DURATION' column_name from dual where p_deliverable_rec.REPEATING_DURATION is null
4628: union
4629: select 'REPEATING_FREQUENCY_UOM' column_name from dual where p_deliverable_rec.REPEATING_FREQUENCY_UOM is null
4630: union
4631: select 'REPEATING_DAY_OF_WEEK' column_name from dual where p_deliverable_rec.REPEATING_FREQUENCY_UOM = 'WK' and p_deliverable_rec.REPEATING_DAY_OF_WEEK is null
4632: union
4633: select 'REPEATING_DAY_OF_MONTH' column_name from dual where p_deliverable_rec.REPEATING_FREQUENCY_UOM = 'MTH' and p_deliverable_rec.REPEATING_DAY_OF_MONTH is null
4634: )
4635: where rownum =1;

Line 4633: select 'REPEATING_DAY_OF_MONTH' column_name from dual where p_deliverable_rec.REPEATING_FREQUENCY_UOM = 'MTH' and p_deliverable_rec.REPEATING_DAY_OF_MONTH is null

4629: select 'REPEATING_FREQUENCY_UOM' column_name from dual where p_deliverable_rec.REPEATING_FREQUENCY_UOM is null
4630: union
4631: select 'REPEATING_DAY_OF_WEEK' column_name from dual where p_deliverable_rec.REPEATING_FREQUENCY_UOM = 'WK' and p_deliverable_rec.REPEATING_DAY_OF_WEEK is null
4632: union
4633: select 'REPEATING_DAY_OF_MONTH' column_name from dual where p_deliverable_rec.REPEATING_FREQUENCY_UOM = 'MTH' and p_deliverable_rec.REPEATING_DAY_OF_MONTH is null
4634: )
4635: where rownum =1;
4636:
4637: okc_api.set_message

Line 4695: select 'RELATIVE_ST_DATE_DURATION' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_DURATION IS NOT NULL

4691: IF p_deliverable_rec.fixed_start_date IS NOT NULL THEN
4692: begin
4693: select column_name into l_column_name from
4694: (
4695: select 'RELATIVE_ST_DATE_DURATION' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_DURATION IS NOT NULL
4696: union
4697: select 'RELATIVE_ST_DATE_UOM' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_UOM is not null
4698: union
4699: select 'RELATIVE_ST_DATE_EVENT_ID' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_EVENT_ID is not null

Line 4697: select 'RELATIVE_ST_DATE_UOM' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_UOM is not null

4693: select column_name into l_column_name from
4694: (
4695: select 'RELATIVE_ST_DATE_DURATION' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_DURATION IS NOT NULL
4696: union
4697: select 'RELATIVE_ST_DATE_UOM' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_UOM is not null
4698: union
4699: select 'RELATIVE_ST_DATE_EVENT_ID' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_EVENT_ID is not null
4700: )
4701: where rownum =1;

Line 4699: select 'RELATIVE_ST_DATE_EVENT_ID' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_EVENT_ID is not null

4695: select 'RELATIVE_ST_DATE_DURATION' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_DURATION IS NOT NULL
4696: union
4697: select 'RELATIVE_ST_DATE_UOM' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_UOM is not null
4698: union
4699: select 'RELATIVE_ST_DATE_EVENT_ID' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_EVENT_ID is not null
4700: )
4701: where rownum =1;
4702:
4703:

Line 4729: select 'RELATIVE_ST_DATE_DURATION' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_DURATION IS NULL

4725: IF p_deliverable_rec.RELATIVE_ST_DATE_EVENT_ID is not NULL THEN
4726: begin
4727: select column_name into l_column_name from
4728: (
4729: select 'RELATIVE_ST_DATE_DURATION' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_DURATION IS NULL
4730: union
4731: select 'RELATIVE_ST_DATE_UOM' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_UOM is NULL
4732: )
4733: where rownum =1;

Line 4731: select 'RELATIVE_ST_DATE_UOM' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_UOM is NULL

4727: select column_name into l_column_name from
4728: (
4729: select 'RELATIVE_ST_DATE_DURATION' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_DURATION IS NULL
4730: union
4731: select 'RELATIVE_ST_DATE_UOM' column_name from dual where p_deliverable_rec.RELATIVE_ST_DATE_UOM is NULL
4732: )
4733: where rownum =1;
4734:
4735:

Line 4762: select 'RELATIVE_END_DATE_DURATION' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_DURATION IS NOT NULL

4758: IF p_deliverable_rec.fixed_end_date IS NOT NULL THEN
4759: begin
4760: select column_name into l_column_name from
4761: (
4762: select 'RELATIVE_END_DATE_DURATION' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_DURATION IS NOT NULL
4763: union
4764: select 'RELATIVE_END_DATE_UOM' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_UOM is not null
4765: union
4766: select 'RELATIVE_END_DATE_EVENT_ID' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_EVENT_ID is not null

Line 4764: select 'RELATIVE_END_DATE_UOM' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_UOM is not null

4760: select column_name into l_column_name from
4761: (
4762: select 'RELATIVE_END_DATE_DURATION' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_DURATION IS NOT NULL
4763: union
4764: select 'RELATIVE_END_DATE_UOM' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_UOM is not null
4765: union
4766: select 'RELATIVE_END_DATE_EVENT_ID' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_EVENT_ID is not null
4767: )
4768: where rownum =1;

Line 4766: select 'RELATIVE_END_DATE_EVENT_ID' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_EVENT_ID is not null

4762: select 'RELATIVE_END_DATE_DURATION' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_DURATION IS NOT NULL
4763: union
4764: select 'RELATIVE_END_DATE_UOM' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_UOM is not null
4765: union
4766: select 'RELATIVE_END_DATE_EVENT_ID' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_EVENT_ID is not null
4767: )
4768: where rownum =1;
4769:
4770:

Line 4796: select 'RELATIVE_END_DATE_DURATION' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_DURATION IS NULL

4792: IF p_deliverable_rec.RELATIVE_END_DATE_EVENT_ID is not NULL THEN
4793: begin
4794: select column_name into l_column_name from
4795: (
4796: select 'RELATIVE_END_DATE_DURATION' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_DURATION IS NULL
4797: union
4798: select 'RELATIVE_END_DATE_UOM' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_UOM is NULL
4799: )
4800: where rownum =1;

Line 4798: select 'RELATIVE_END_DATE_UOM' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_UOM is NULL

4794: select column_name into l_column_name from
4795: (
4796: select 'RELATIVE_END_DATE_DURATION' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_DURATION IS NULL
4797: union
4798: select 'RELATIVE_END_DATE_UOM' column_name from dual where p_deliverable_rec.RELATIVE_END_DATE_UOM is NULL
4799: )
4800: where rownum =1;
4801:
4802:

Line 5209: FROM DUAL;

5205: IF p_deliverable_rec.deliverable_id = okc_api.g_miss_num
5206: THEN
5207: SELECT okc_deliverable_id_s.NEXTVAL
5208: INTO p_deliverable_rec.deliverable_id
5209: FROM DUAL;
5210: END IF;
5211:
5212: IF p_deliverable_rec.business_document_type = okc_api.g_miss_char
5213: THEN

Line 5821: select okc_deliverable_id_s.nextval INTO delRecTab.deliverable_id from dual;

5817:
5818: END IF;
5819:
5820: IF delRecTab.deliverable_id IS NULL OR delRecTab.deliverable_id = OKC_API.g_MISS_NUM THEN
5821: select okc_deliverable_id_s.nextval INTO delRecTab.deliverable_id from dual;
5822: delRecTab.original_deliverable_id := delRecTab.deliverable_id;
5823: END IF;
5824:
5825: INSERT INTO okc_deliverables