DBA Data[Home] [Help]

APPS.CN_QUOTAS_PKG dependencies on CN_API

Line 278: DECODE (x_expense_account_id, cn_api.g_miss_id, NULL, x_expense_account_id),

274: x_interval_type_id,
275: x_payee_assign_flag,
276: x_vesting_flag,
277: x_addup_from_rev_class_flag,
278: DECODE (x_expense_account_id, cn_api.g_miss_id, NULL, x_expense_account_id),
279: DECODE (x_liability_account_id, cn_api.g_miss_id, NULL, x_liability_account_id),
280: x_quota_group_code,
281: --clku, PAYMENT ENHANCEMENT
282: x_payment_group_code,

Line 279: DECODE (x_liability_account_id, cn_api.g_miss_id, NULL, x_liability_account_id),

275: x_payee_assign_flag,
276: x_vesting_flag,
277: x_addup_from_rev_class_flag,
278: DECODE (x_expense_account_id, cn_api.g_miss_id, NULL, x_expense_account_id),
279: DECODE (x_liability_account_id, cn_api.g_miss_id, NULL, x_liability_account_id),
280: x_quota_group_code,
281: --clku, PAYMENT ENHANCEMENT
282: x_payment_group_code,
283: --clku, 2854578

Line 464: expense_account_id = DECODE (x_expense_account_id, cn_api.g_miss_id, recinfo.expense_account_id, x_expense_account_id),

460: interval_type_id = x_interval_type_id,
461: payee_assign_flag = x_payee_assign_flag,
462: vesting_flag = x_vesting_flag,
463: addup_from_rev_class_flag = x_addup_from_rev_class_flag,
464: expense_account_id = DECODE (x_expense_account_id, cn_api.g_miss_id, recinfo.expense_account_id, x_expense_account_id),
465: liability_account_id = DECODE (x_liability_account_id, cn_api.g_miss_id, recinfo.liability_account_id, x_liability_account_id),
466: quota_group_code = x_quota_group_code,
467: --clku, PAYMENT ENHANCEMENT
468: payment_group_code = x_payment_group_code,

Line 465: liability_account_id = DECODE (x_liability_account_id, cn_api.g_miss_id, recinfo.liability_account_id, x_liability_account_id),

461: payee_assign_flag = x_payee_assign_flag,
462: vesting_flag = x_vesting_flag,
463: addup_from_rev_class_flag = x_addup_from_rev_class_flag,
464: expense_account_id = DECODE (x_expense_account_id, cn_api.g_miss_id, recinfo.expense_account_id, x_expense_account_id),
465: liability_account_id = DECODE (x_liability_account_id, cn_api.g_miss_id, recinfo.liability_account_id, x_liability_account_id),
466: quota_group_code = x_quota_group_code,
467: --clku, PAYMENT ENHANCEMENT
468: payment_group_code = x_payment_group_code,
469: -- clku, 2854576

Line 629: x_start_date => cn_api.next_period (recinfo.end_date, recinfo.org_id),

625: x_start_period_id => NULL -- obsolete
626: ,
627: x_end_period_id => NULL -- obsolete
628: ,
629: x_start_date => cn_api.next_period (recinfo.end_date, recinfo.org_id),
630: x_end_date => x_end_date
631: );
632: -- mark the Event only mark the new period records
633: -- bug 3646625, fix the passed in p_start_end

Line 652: x_start_date => cn_api.next_period (recinfo.end_date, recinfo.org_id),

648: x_quota_id => x_quota_id,
649: x_revenue_class_id => NULL,
650: x_start_period_id => NULL,
651: x_end_period_id => NULL,
652: x_start_date => cn_api.next_period (recinfo.end_date, recinfo.org_id),
653: x_end_date => x_end_date
654: );
655: ELSIF recinfo.end_date IS NULL
656: THEN

Line 677: x_start_date => cn_api.next_period (x_end_date, recinfo.org_id),

673: x_start_period_id => NULL -- obsolete
674: ,
675: x_end_period_id => NULL -- obsolete
676: ,
677: x_start_date => cn_api.next_period (x_end_date, recinfo.org_id),
678: x_end_date => recinfo.end_date
679: );
680: -- x_end_date is not null and less end_date
681: -- RC 1

Line 688: x_start_date => cn_api.next_period (x_end_date, recinfo.org_id),

684: x_quota_id => x_quota_id,
685: x_revenue_class_id => NULL,
686: x_start_period_id => NULL,
687: x_end_period_id => NULL,
688: x_start_date => cn_api.next_period (x_end_date, recinfo.org_id),
689: x_end_date => recinfo.end_date
690: );
691: ELSIF TRUNC (x_end_date) > TRUNC (recinfo.end_date)
692: THEN

Line 701: x_start_date => cn_api.next_period (recinfo.end_date, recinfo.org_id),

697: x_start_period_id => NULL -- obsolete
698: ,
699: x_end_period_id => NULL -- obsolete
700: ,
701: x_start_date => cn_api.next_period (recinfo.end_date, recinfo.org_id),
702: x_end_date => x_end_date
703: );
704: -- mark the Event only mark the new period records
705: -- bug 3646625, fix the passed in p_start_end

Line 724: x_start_date => cn_api.next_period (recinfo.end_date, recinfo.org_id),

720: x_quota_id => x_quota_id,
721: x_revenue_class_id => NULL,
722: x_start_period_id => NULL,
723: x_end_period_id => NULL,
724: x_start_date => cn_api.next_period (recinfo.end_date, recinfo.org_id),
725: x_end_date => x_end_date
726: );
727: ELSE
728: -- shorten end_date

Line 749: x_start_date => cn_api.next_period (x_end_date, recinfo.org_id),

745: x_start_period_id => NULL -- obsolete
746: ,
747: x_end_period_id => NULL -- obsolete
748: ,
749: x_start_date => cn_api.next_period (x_end_date, recinfo.org_id),
750: x_end_date => cn_api.next_period (recinfo.end_date, recinfo.org_id) -- bugfix 4042235
751: );
752: cn_srp_per_quota_rc_pkg.DELETE_RECORD
753: (x_srp_plan_assign_id => NULL,

Line 750: x_end_date => cn_api.next_period (recinfo.end_date, recinfo.org_id) -- bugfix 4042235

746: ,
747: x_end_period_id => NULL -- obsolete
748: ,
749: x_start_date => cn_api.next_period (x_end_date, recinfo.org_id),
750: x_end_date => cn_api.next_period (recinfo.end_date, recinfo.org_id) -- bugfix 4042235
751: );
752: cn_srp_per_quota_rc_pkg.DELETE_RECORD
753: (x_srp_plan_assign_id => NULL,
754: x_quota_id => x_quota_id,

Line 758: x_start_date => cn_api.next_period (x_end_date, recinfo.org_id),

754: x_quota_id => x_quota_id,
755: x_revenue_class_id => NULL,
756: x_start_period_id => NULL,
757: x_end_period_id => NULL,
758: x_start_date => cn_api.next_period (x_end_date, recinfo.org_id),
759: x_end_date => cn_api.next_period (recinfo.end_date, recinfo.org_id) -- bugfix 4042235
760: );
761: END IF;
762: ELSE

Line 759: x_end_date => cn_api.next_period (recinfo.end_date, recinfo.org_id) -- bugfix 4042235

755: x_revenue_class_id => NULL,
756: x_start_period_id => NULL,
757: x_end_period_id => NULL,
758: x_start_date => cn_api.next_period (x_end_date, recinfo.org_id),
759: x_end_date => cn_api.next_period (recinfo.end_date, recinfo.org_id) -- bugfix 4042235
760: );
761: END IF;
762: ELSE
763: -- mark the Event only mark the delete period records